New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for
Did you mean:
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
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

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?