Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Comparing Month to Month Trend with Indicators

Hello,

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:

=Avg([UMHC SYSTEM])

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(),

Black())))


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!


Capture_7_25_18.PNG