Home Business Analytics How To Merge Sheets In Qlik Sense

How To Merge Sheets In Qlik Sense

How To Merge Sheets In Qlik Sense


Qlik Sense gives a self-service enterprise intelligence setting for enterprise customers to discover information and generate insights. Additional, customers can create their very own dashboards or stories, all with out having to depend on IT, information scientists, or analysts. Self-service BI provides all staff entry to insights that may assist them make higher choices, no matter analytics abilities. The premise of self-service additionally signifies that Qlik Sense customers can create sheets inside an software that always will should be merged into the unique base software.

A doable state of affairs of that is Gross sales Rep A, knowledgeable consumer, has duplicated the printed Gross sales Software, which incorporates 4 base sheets, into his Work stream. Gross sales Rep A then creates 2 extra sheets inside this copy of the appliance. This Gross sales App is now 4 base sheets plus 2 new sheets. Gross sales Rep B, one other skilled consumer, additionally creates a duplicate of the Gross sales App and creates 4 new sheets of his personal. 

Merging sheets inside a Qlik Sense software

Subject: How can we replace the Gross sales Software to comprise all sheets developed in several variations of the appliance?


Time wanted: 5 minutes.

The right way to merge sheets in Qlik Sense

  1. Log into the Qlik Sense QMC utilizing an Administrator login.

    When you login, navigate to App objects to seek out all of the newly created sheets.

  2. Choose sheet, click on Edit, and alter the proprietor identify to Administrator.

    After switching the proprietor identify, all of the sheets ought to present underneath My Sheets within the Gross sales Software while you launch the app from the Administrator Work stream.

The Administrator has all of the sheets consolidated into one software. Now you can publish the up to date app with all of the sheets!

Including sheets to public sheets

Later variations of Qlik Sense enable builders to approve printed sheets (each printed sheets owned by them or group sheets) so as to add them to the general public sheets of the app. Sheets added to the general public sheets, in contrast to printed sheets, are included when an app is duplicated or exported. Including sheets to your public sheets allows you to collaboratively develop the general public sheets of your app. You may combine these into the bottom software as public sheets by doing the next:

  1. Open the appliance by way of the Qlik Sense Hub
  2. Proper-click on a group sheet or one among your printed sheets and choose Approve.
  3. The chance to un-promote a base sheet and transfer it again into the Group Sheet part is out there.

The printed sheet is now included within the public sheets of the app. Merging these user-developed sheets into the general public app permits for builders to work individually and mix efforts when prepared. 



Please enter your comment!
Please enter your name here