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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jomeh97
Contributor
Contributor

Multi KPI - Conditional Formatting (icon & color)

Hi all,

I have the following multi KPI visualization

jomeh97_0-1623768150551.png

with dimension "YearQuarter" and measure "Spend".

I want to be able to format both the color and icon depending on whether the spend increases or decreases.

First and foremost, the icons are incorrect which I don't quite understand as I've used the following expression:

=if ( ( Sum(Spend)/Below(Sum(Spend)) ) > 1, 'lui-icon lui-icon--triangle-top', 'lui-icon lui-icon--triangle-bottom')

Secondly, I can't find any option to use conditional formatting for colors. For example, if the spend is higher compared to the previous period, the icon should be triangle-top and color green. 

Is this something anyone can help with?

 

Labels (1)
1 Reply
jomeh97
Contributor
Contributor
Author

No one with any input regarding this?