Thursday, April 18, 2024

How To Merge Sheets In Qlik Sense


Qlik Sense gives a self-service trade intelligence setting for trade customers to discover information and generate insights. Additional, customers can create their very own dashboards or experiences, all with no need to depend on IT, information scientists, or analysts. Self-service BI offers all workers get entry to to insights that may assist them make higher choices, irrespective of analytics abilities. The basis of self-service additionally signifies that Qlik Sense customers can create sheets inside of an software that incessantly will want to be merged into the unique base software.

A conceivable state of affairs of that is Gross sales Rep A, a certified consumer, has duplicated the broadcast Gross sales Software, which accommodates 4 base sheets, into his Paintings move. Gross sales Rep A then creates 2 further sheets inside of this reproduction of the appliance. This Gross sales App is now 4 base sheets plus 2 new sheets. Gross sales Rep B, any other skilled consumer, additionally creates a duplicate of the Gross sales App and creates 4 new sheets of his personal. 

Merging sheets inside of a Qlik Sense software

Factor: How are we able to replace the Gross sales Software to comprise all sheets advanced in numerous variations of the appliance?


Time wanted: 5 mins.

merge sheets in Qlik Sense

  1. Log into the Qlik Sense QMC the usage of an Administrator login.

    If you login, navigate to App gadgets to seek out the entire newly created sheets.

  2. Make a selection sheet, click on Edit, and alter the landlord identify to Administrator.

    After switching the landlord identify, the entire sheets will have to display underneath My Sheets within the Gross sales Software while you release the app from the Administrator Paintings move.

The Administrator has the entire sheets consolidated into one software. You’ll now submit the up to date app with the entire sheets!

Including sheets to public sheets

Later variations of Qlik Sense permit builders to approve revealed sheets (each revealed sheets owned through them or group sheets) so as to add them to the general public sheets of the app. Sheets added to the general public sheets, not like revealed sheets, are integrated when an app is duplicated or exported. Including sheets in your public sheets lets you collaboratively broaden the general public sheets of your app. You’ll combine those into the bottom software as public sheets through doing the next:

  1. Open the appliance by means of the Qlik Sense Hub
  2. Proper-click on a group sheet or one in every of your revealed sheets and choose Approve.
  3. The likelihood to un-promote a base sheet and transfer it again into the Neighborhood Sheet segment is to be had.

The broadcast sheet is now integrated within the public sheets of the app. Merging those user-developed sheets into the general public app lets in for builders to paintings one by one and mix efforts when in a position. 


Please enter your comment!
Please enter your name here

Related Stories