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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Creator III
Creator III

KPI - Color Condition Formatting Based upon an expression not working

Hi 

I have a KPI and I would like to have following set for the Color - Expression Formula:

 

=IF(SUM({<[IDate.autoCalendar.Year]={'$(vPriorYear2)'}>}IAmount) >= SUM({<[IDate.autoCalendar.Year]={'$(vPriorYear)'}>}IAmount),.75,.25)

 

If the Prior Year 2 IAmount is greater than the Prior Year IAMount, the color should be green, if not red.

The result is automatically defaulting to red, why ? thoughts ? Jerry

KPI-Setting.JPG

 

 
1 Solution

Accepted Solutions
Kushal_Chawda

I think you can put single expression conditional color which compares the value with actual KPI expression automatically.

Let's say your KPI measure expression is  below

SUM({<[IDate.autoCalendar.Year]={'$(vPriorYear2)'}>}IAmount)

Now in Appearance->Color->Add limit you can just put below expression. This will give you two different segment for which you can set two different color according to your requirement

SUM({<[IDate.autoCalendar.Year]={'$(vPriorYear)'}>}IAmount)

 

 

View solution in original post

1 Reply
Kushal_Chawda

I think you can put single expression conditional color which compares the value with actual KPI expression automatically.

Let's say your KPI measure expression is  below

SUM({<[IDate.autoCalendar.Year]={'$(vPriorYear2)'}>}IAmount)

Now in Appearance->Color->Add limit you can just put below expression. This will give you two different segment for which you can set two different color according to your requirement

SUM({<[IDate.autoCalendar.Year]={'$(vPriorYear)'}>}IAmount)