Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reutilize master measure in another master measure in Qlik Sense

I've noticed that now you can use master measure in another master measure, eg.:

Meas. 1               TotalAmount              =       Sum(Amount)   

Meas. 2               TotalQty                    =        Sum(Qty)

Meas. 3                Average                    =       TotalAmount/TotalQty

If you put in a table all the three master measures they work fine, but if you remove Meas1 or Meas2 you have null in the Meas3 column.

The same apply if you use Meas3 alone.

Anyone has solved the issue?

thanks in advance

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can't use master measures as if they are variables. The measures only make sense in the context of the object they're used. What you want instead is variables and use those. In Qlik Sense 2.1 you can create variables in the user interface. In older versions you need to create them in the script.

SET vTotalAmount = sum(Amount);

SET vTotalQty = sum(Qty);

LET vAverage = '$('& 'vTotalAmount)/$(' & 'vTotalQty)';

You can then use the variables in the measures:

=$(vTotalAmount)

=$(vTotalQty)

=$(vAverage)


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
alextimofeyev
Partner - Creator II
Partner - Creator II

Hi,

you can can move measure definitions to variables:

Meas. 1   TotalAmount = $(vTotalAmount)

Meas. 2   TotalQty = $(vTotalQty)

Meas. 3   Average = $(vAverage)

Variables:

vTotalAmount = Sum(Amount)

vTotalQty= Sum(Qty)

vAverage = $(vTotalAmount)/$(vTotalQty)

Gysbert_Wassenaar

You can't use master measures as if they are variables. The measures only make sense in the context of the object they're used. What you want instead is variables and use those. In Qlik Sense 2.1 you can create variables in the user interface. In older versions you need to create them in the script.

SET vTotalAmount = sum(Amount);

SET vTotalQty = sum(Qty);

LET vAverage = '$('& 'vTotalAmount)/$(' & 'vTotalQty)';

You can then use the variables in the measures:

=$(vTotalAmount)

=$(vTotalQty)

=$(vAverage)


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks for your reply, for end-users was easier to use Master Items instead of variables.

Anyway you (and Alex) are right.

Gysbert_Wassenaar

You can still use the Master Items. You just have to create them using the variables.


talk is cheap, supply exceeds demand
shilpan
Partner Ambassador
Partner Ambassador

I created a short video on how to re-use master items.

https://youtu.be/YZ-bc5Sx_Bk