Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannagr
Creator III
Creator III

conditional coloring of KPI measure

New week, new questions for me 😂

I want to understand how this limit in conditional coloring in KPI works.

Say that i have the following measure that counts the amount of IDs with a max date declared.

=count({1}distinct [ID]) - count({<[date]= {'$(=max([date))'}>}distinct [ID])

This number i want to be RED if not 0, 

Green if 0.

In the limit condition, shall i write count({1}distinct [ID]) - count({<[date]= {'$(=max([date))'}>}distinct [ID]) <>0 and check red color for the area to the right of the limit range and green to the left of it?

 

2 Replies
Rajesh5kumar
Contributor II
Contributor II

In KPI--> Color---> Conditional color---> Set Limits---->Add Limits---> after you add limits---->you can click on the limit to change the color...

 

 

Regards

Kumar

ioannagr
Creator III
Creator III
Author

@Rajesh5kumar but my logic for 

-lets quote my above post-

"In the limit condition, shall i write count({1}distinct [ID]) - count({<[date]= {'$(=max([date))'}>}distinct [ID]) <>0 and check red color for the area to the right of the limit range and green to the left of it?"

 

is correct?