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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Karthick30
Creator
Creator

Up or Down Indicators in KPI

I have created a KPI. which will show total number of users in an organisation. Its running on daily basis.

Now I need to show one indicator which is Up or down based on yesterday value. If value is less than yesterday means decrease show or if value is increased means, it has to show Up indicator.

Tried few community links , but everything is for Table and pivot. but i need it in Vizlib KPI or native KPI. 

Any help on this

Labels (2)
1 Solution

Accepted Solutions
Or
MVP
MVP

You would set the icon based on the condition.

=if(A>B,'fa-arrow-up','fa-arrow-down')

View solution in original post

4 Replies
Or
MVP
MVP

I don't know if this is feasible in the native object, but it should be trivial in the Vizlib KPI object. Just add a layer with an icon and then set the specific icon based on your two formulas.

[Edit] For the native KPI object you can use the second measure for this, e.g.

=if(A>B,'▲')

Karthick30
Creator
Creator
Author

If I add Layer in Vizlib and choose Icon and enter Fa-Arrow Up..  its not showing me to enter formula to check the condition. I am getting Icon size , Number of icons,...

Also If I choose ArrowUp in Icon , how it will change for decrease condition

 

Or
MVP
MVP

You would set the icon based on the condition.

=if(A>B,'fa-arrow-up','fa-arrow-down')

Karthick30
Creator
Creator
Author

Great. It worked. Thanks much