idea Re: Using Master Items in Expressions in Suggest an Idea

Using Master Items in Expressions

jheasley — Wed, 25 Nov 2020 15:38:50 GMT

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")

Re: Using Master Items in Expressions

Oliver_F — Fri, 08 May 2020 11:02:50 GMT

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.

Re: Using Master Items in Expressions

millerhm — Fri, 08 May 2020 13:04:53 GMT

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.

Re: Using Master Items in Expressions - Status changed to: Closed - Duplicate

John_Teichman — Mon, 11 May 2020 07:18:30 GMT

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