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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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?