Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. 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.