Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I see the document about the usage of measures modifiers, but I don't understand the related expressions.
Can someone help explain to me?
the document url:https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Measures/modifiers.htm
Syntax:
RangeSum(Above {$M,0,Steps})
$M - Above($M)
RangeAvg(Above ($M,0,Steps))
$M / Sum( total Aggr( $M, dim ) )
I don’t know much about the above expressions, such as $M
will be grateful for your help.
I would suggest not to get confused with $M and it's combination with above(). '$M' is nothing but a place holder for modifier here which could be 'Total' in this scenario. You should read above from here :Above function in qlik separately for better understanding.