Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I want to have my KPI fonts color conditioned, with the fonts color in blue when the number is higher than zero, and turn red when the results is below zero. having tried to build master measure with conditional color with limit in zero, but it doesn't work out changing the fonts color automatically. does anyone can help with this?? thanks!
Hi,
For QlikSense Desktop version you need to paste that zip file in Documents/Qlik/Sense/Extension/templates
after that unzip that file in the location
go to qliksense desktop version press F5, it will refresh the particular app.
Thanks
Tushar
Hi,
Actually i don't know the proper meaning for that but i think it would be the colour percentage value.
I am not getting that option as well..
Thanks
Tushar
Yes, just download the updated version and paste it in the same path,
make sure that old version folder has to be removed
Thanks
Tushar
Okay, I have downloaded the extension. I've used it successfully with a graph, but now, I'm trying to do with a KPI, but I'm not being given the same choices. Doesn't this work with KPIs?
@tush wrote:Hi,
I think you are looking for change in colour based on year over year sales, which can be achieved using Extension named "Climber KPI", you can use directly it by adding two measures which you want to compare or you can add formula in the Appearance/colour/text expression as:-
=If(Sum({<[Order Date.autoCalendar.Year]={"$(=Year(Max([Order Date])))"}>}Sales) > Sum({<[Order Date.autoCalendar.Year]={"$(=Year(Max([Order Date]))-1)"}>}Sales),Green(),Red())
Please find attached file for Climber KPI.
Thanks
Tushar