Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is it possible to use a Master-Item in a Formula?
I'm using exact the same formula twice: 1x for dimension-sorting and 1x as a Master key indicator (see attachment).
Thanks.
Yes, when you create a measure as a master item, you are able to add this master measure once you click on add measure, as master items will appear.
Once you added this master measure, in order to sort by the master measure, you just need to put at the top of the sort panel the master dimension
In my case it does not appear. Tried with the master name and master labelname.
Have 3 master items in the sorting tab. One of them is a master measure, but I can't put this at the top of the sort. the others below (Nr 2 & 3) the order can be changed. So then I tried to do a workaround by puting a formula in the first master dimension item (my screenshot Nr1). It worked fine by puting the formula "count(..)", but not with the mastername.
You cannot yet refer to a Master Item in an expression. It can only be used stand alone. For example, given a master measure named "Sales" you cannot do:
Sales / 1000
As a workaround you can put your measures in a variable and use the variable to establish the master measure. Then use the variable form when you need reuse. Example:
SET e.Sales = (Sum(LineTotal - Discount));
Master Measure Sales: $(e.Sales)
In an expression: $(e.Sales) / 1000
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
This was my worry. Tried to bypass by using a Variable. Your solution will work, but needs an extra effort.
Does anybody know, if this feature will implemented once as new feature in a new Qlik Sense version?