Saturday, December 3, 2022
HomeBusiness AnalyticsHow To Merge Sheets In Qlik Sense

How To Merge Sheets In Qlik Sense

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

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

Merging sheets inside a Qlik Sense utility

Situation: How can we replace the Gross sales Software to include all sheets developed in several variations of the applying?


Time wanted: 5 minutes.

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 beneath My Sheets within the Gross sales Software whenever you launch the app from the Administrator Work stream.

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

Including sheets to public sheets

Later variations of Qlik Sense permit 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 lets you collaboratively develop the general public sheets of your app. You’ll be able to combine these into the bottom utility as public sheets by doing the next:

  1. Open the applying through the Qlik Sense Hub
  2. Proper-click on a group sheet or one in all your printed sheets and choose Approve.
  3. The chance to un-promote a base sheet and transfer it again into the Neighborhood 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

Most Popular

Recent Comments