Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Use Master Measures and Dimensions across multiple apps

agherbert4
Partner - Contributor III
Partner - Contributor III

Use Master Measures and Dimensions across multiple apps

Currently master measures and dimensions are specific to the app in which they were created. It would be extremely helpful if you could share these across multiple apps (maybe one depository of master measures/dimensions). Whenever we change a calculation, you have to find all apps that calculation might exist in and update everywhere. It would be much easier to just go to one place.

10 Comments
adam_townsend
Contributor
Contributor

Super Like

Klaus75
Partner - Contributor II
Partner - Contributor II

The best thing beside dialogs for define which ones get shared would be the possibility of a extension of the Qlik script language with additional commands / special "loads" so that we could import own definitions of master dimensions and measures from own - already exisiting - repositories (DB, Excel or source system based or combinations of this). I think this would be the least effort for Qlik and the maximum flexibility for different usage scenarios. 

Many partners use already own scripting frameworks and formula repositories (often Excel based) to load at least master measure (named Qlik formulas) from there and generate variables for each measure which then are entered in the master measures. So if the formula changes it can be done in the repository and after the next reload is consistent in all master elements. But the first creation of the master elements especially the measures is a pain in the a... 😉 ... 

Besides the commands to import from the Qlik Script language (over the APIs to the regulär Qlik Repository) there should be commands to get a list of existing master elements (at least for dimensions and measures) and the possibilty to delete single elements or all. As well das Update functions.

Over this import/update functions it should be possible to define things like name, field/expression, label/label expression, default color (opt.) as well as the generally missing point of default number format in case of master elements! And no the ussage of "num(qlik exp., '#.##0,00')' is no solution for it. The best would be if 2 formats can be specified. One for the display of absolut values ('#.##0,00 €') and the other for usage in the display of relativ values ('##0,0 %'). In the concret chart the user would then only switch between "absolut / relativ value" and it would be consistent thru the hole app or all apps 😉 ...

This points would make a huge difference in the effort of Qlik app development and maintenance!

 

 

Anonymous
Not applicable
 
John_Teichman
Former Employee
Former Employee
 
Status changed to: Open - New
John_Teichman
Former Employee
Former Employee
 
Status changed to: Open - Collecting Feedback
AndrewMcIlwrick
Luminary Alumni
Luminary Alumni

There is a discussion on LinkedIn thread on similar topic 🙂 It is actually quite complicated imo and worthy of luminary coordination or QlikWorld session.

torstendiehl
Partner - Contributor
Partner - Contributor

I like the idea to have Master Measure and Dimensions across multiple apps, would be very helpful for many projects to have this functionality available one day...

 

Best wishes,

Torsten

ajaykakkar93
Specialist III
Specialist III

Hi Everyone,

I can help on this connect me on

LinkedIn or twitter or  ajaykakkar93@gmail.com

 

Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived