Qlik Community

Suggest an Idea

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Use master item in expression in function

sophie_bd
Partner
Partner

Use master item in expression in function

Re-use the master item in expression.

12 Comments
Michael_Tarallo
Employee
Employee

This has been entered into our internal ideation system and is awaiting consideration.

Status changed to: Active
Oleg_Troyansky

If Master Items get a "face lift", can I add a couple of features that would make them so much more useful:

- Master Measures should carry their default "Number formatting". There is nothing more irritating than the need to always set the same number format over and over again, when using Master Measures in multiple charts. 99% of the time, the number format won't change from one chart to another. Having said that, an ability to override it when needed, would be helpful.

- Many times we are forced to un-link Measures and Dimensions from Master Items, just to override the default Label. It would be extremely helpful if we could override the Master Item Label at the chart level.

- It would be great to have a better development tool for Master Items. In large applications with hundreds of Master Measures, it is extremely hard to work with the left-side panel that doesn't show full names, and scrolls back to the top of the list after every edit... If we could have a full-screen option that could be opened on demand, with better editing tools, it would make the job a lot easier and more pleasant.

Cheers,

Oleg Troyansky

robert99
Specialist III
Specialist III

The other thing that's needed is a way to open the master dimension by clicking in the right hand greyed out measure or dimension. Say double click and it opens up the master dimension

Its a pain moving across to the left hand side and searching for it (and I assume this would be a fairly simple change).

 

robert99
Specialist III
Specialist III

Also

-Maybe the ability to export master measures. To see them all in say excel.

-By reuse. I would like the option to convert the master measure to a value and then use this value by the charts dimensions in another measure.(Nesting one master measure in another one?). I know sum(aggr... etc can be used but its confusing to learn. And I would also like to be able to do everything using master measures.

Also using for coloring etc. but I would like more than just the equivalent of a variable.

 

 

 

WiscoSippi
Creator
Creator

In my ideal setup, variables and master items all work the same way. Add the re-usability of variables to master items and add the control and structure of master items to variables. In fact, I think variables could cease to exist if master items were properly structured. 

robert99
Specialist III
Specialist III

Another suggestion regarding self service

It should be possible for the owner of an App to lock  Master Items as required. This would mean the owner could change but not anyone else.

Or it could be set-up (a bit) like sheets in some way. So users have their own set of master items. These master items can be set as

  •  Locked (the default open) - they can be used in an sheet but not changed or copied. They would be invisible and locked to all but the App owner
  •  Allow copy - they can be used in an sheet but not changed. They would be visible to all who have self service rights and duplicate would be allowed
  •  Open - so anyone with self service rights can change or duplicate as required.

     

 

Patric_Nordstrom
Employee
Employee

Re-using master expressions in expressions are on the roadmap for 2020, most likely during the fall.

Thanks, 

Patric

Status changed to: Open - Collecting Feedback
Patric_Nordstrom
Employee
Employee
 
Status changed to: Open - On Roadmap
Patric_Nordstrom
Employee
Employee

Re-using master expressions in expressions is most likely coming in Feb 2021.

Thanks, 
Patric

Status changed to: Open - In Development
rzenere_methode
Partner
Partner

Looking forward for this enhancencement!