Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.