Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
cindy_user
Contributor III
Contributor III

How to understand the expression of Measures modifiers,such as RangeSum(Above {$M,0,Steps})

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.

 

Labels (2)
1 Reply
tresesco
MVP
MVP

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.