Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannaiogr
Creator II
Creator II

dynamic limit colour changing for KPI

Hi,

I have an expression of CYTD-LYTD 

fabs(count({1}{<[date]={">=$(=YearStart(Max(date([date],'DD/MM/YYYY'))))<=$(=date(MakeDate(Year(Max([date])),Month(Today()),Day(Today(0)-1)),'DD/MM/YYYY'))"},[year]=, [month]=>} id)
-count({1}{<[date]={">=$(=YearStart(Max(date([date]),'DD/MM/YYYY'),-1))<=$(=date(MakeDate(Year(Max([date]))-1,Month(Today()),Day(Today(0)-1)),'DD/MM/YYYY'))"},[year]=, [month]= >} id)

)

I set the coloring limit to the second part for LYTD like so:

count({1}{<[date]={">=$(=YearStart(Max(date([date]),'DD/MM/YYYY'),-1))<=$(=date(MakeDate(Year(Max([date]))-1,Month(Today()),Day(Today(0)-1)),'DD/MM/YYYY'))"},[year]=, [month]= >} id)

and over this LYTD i want the color to be green and use the upwards triangle

and below this LYTD i want the color to be red and use the downwards triangle

For 2021 the count is 837519

For 2020 the count is 688032, so this  KPI should show 149487 with the upwards triangle, well it shows 149487 with the downwards triangle.

 

Any idea what is wrong here?

 

0 Replies