Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Using Master Items in Expressions

jheasley
Creator III
Creator III

Using Master Items in Expressions

A master item should be able to be called in an expression, the same way a variable is called. Layering these would allow for much cleaner and easier to read scripting. for example, a function like M() with the parameter as the item name.

Some Sales KPI :
(Sum({<field1={'list of values'}>}Revenue) - Sum({<field2={'several numbers'}>}Costs)) + Sum({<field3{'just one value'}>}VendorRebates)

Some Other KPI:
Sum({<field4={'list of values indicating that a customer bought something'}>}Customers)

average Sales KPI for Customers that Bought Something could be:
M("Some Sales KPI") / M("Some Other KPI")

Tags (2)
3 Comments
Oliver_F
Partner - Creator III
Partner - Creator III

I would even go a step further. If Masteritems become more variable-like, it would be amazing to be allowed to use (optional) parameters with them. So you can have a master item (e.g. Sales per Year) where you can add a parameter (2017,2018, etc) - That would help a lot and would go along quite nice with this idea.

millerhm
Partner - Creator
Partner - Creator

Agree - we have a lot of duplication (i.e., create the same measure as both a variable and a MI) because I need the master item for coloring, labeling, etc, but need the variable because the measure is embedded in other measures. A merging of these functionalities would go a long way to keeping apps clean and consistent.

John_Teichman
Former Employee
Former Employee

Hello @jheasley,

Thank you for your feedback. This idea has been proposed a previously. The other idea is currently marked as being on the roadmap. Please show your support for the previous idea by liking and commenting there.

https://community.qlik.com/t5/Ideas/Use-master-item-in-expression-in-function/idi-p/1581435

Additionally, here are a some other ideas that are very similar:

https://community.qlik.com/t5/Ideas/Master-Item-based-on-master-items/idi-p/1677288

https://community.qlik.com/t5/Ideas/Master-Item-Variable/idi-p/1672002

 

 

 

 

Status changed to: Closed - Duplicate