Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Comparing Month to Month Trend with Indicators


I have a pivot table that has two columns, one shows the average compliance score then the next column shows the trend with arrow indicators.

For the compliance average I use this expression:


For the arrow indicators I use this expression:

If(Avg([UMHC SYSTEM]) >0.945,Black(),

If(Avg([UMHC SYSTEM])>0.84,Black(),

If(Avg([UMHC SYSTEM])>0,lightRed(),


What I want to do is have the trend indicator arrow go up if the percentage from month to month is going up, and an arrow going down if the percentages have gone down from month to month. And if there is no change just a dash.

Can anyone help me with this?

Thank you!