Performance Indicator

[QlikBeginner1]

Hello,

I am trying to use the performance indicator feature, and struggling on how to create the measure to calculate the indicator to work correctly.

I would like the indicators to show up or down depending on the previous month, so for example, top row Jul 22 shows 284, it should shown a downward arrow. The June 22 has 754, this should show a downword arrow because its less then May 22 which is 797, May should have an upward arrow because its greater then April 22, which is 594. 

IF(ABOVE(Count({$< [Created Date]={">=$(=v6MonthsToday)<=$(=vTodayDate)"}, recordMain={1}, latest_record={1}>} rfq_key)),RED(),GREEN())

[edwin]

it appears you are using a pivot.  try using BEFORE function instead of ABOVE

[edwin]

@QlikBeginner1  can you pls tell me what verion of QLik Sense you are using?

[QlikBeginner1]

Hi Edwin, thanks for the response, This is the Qlik Sense May 2021 Patch 8 version. 

I did try and use a above function, and it doesnt change the results 

IF(BEFORE(Count({$< [Created Date]={">=$(=v6MonthsToday)<=$(=vTodayDate)"}, recordMain={1}, latest_record={1}>} rfq_key)),RED(),GREEN())

[QlikBeginner1]

@edwin 

[edwin]

sorry someone else may be able to help, i dont have the same version as you

i dont have the same options fo rthe indicator

[QlikBeginner1]

This is also using the Vizlib Extension, which functionality was you specifying would work with the before function ? @edwin