Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
Michael_Tarallo
Employee
Employee

     When creating analytics - you may want to use specific calculations within your charts to view your measures differently or possibly even combine standard aggregated measures ( SUM(Sales) ) with more advanced calculations (Moving Average). Now - this could always be done of course, but you would need to create the specific expression using a combination of available Qlik functions such as RangeSum, Above, Replace along with aggregate functions such as SUM, MIN and MAX, etc. This can get tedious, is time consuming and error prone. 

Measure modifiers have been designed to easily add these specific calculations without the need to create these expressions.

Currently there are 4 Measure Modifiers:

  • Accumulation -  see accumulated values of a measure over dimensions.
  • Difference - see the difference between consecutive values of a measure.
  • Moving Average - see the average values of a measure over a specific period.
  • Relative Number -  see relative percentages.

 

We realize the importance of these expressions and how easy they are to use, so we plan on adding additional ones that make sense in future releases.

Watch this 60 second video to see how easy it is to use Measure Modifiers

Learn more:

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Measures/modifiers....

Don't have access to YouTube? - Download the attached .mp4 to watch on your computer or mobile device.