Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?