Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
bdunphy
Contributor III
Contributor III

Colour KPI object based on prior year

Hi,

I have a KPI object which i want to display Current YTD Sales - with the smaller number showing Prior YTD Sales.

I would also like to colour based on this calc. However - it will only allow a numeric to be entered in the limit.

It is unlikely that i would like to change the colour or icon based on whether we sold > 2 million for example.

I would like it to be dynamic and show based on the prior year so it would work for any selections.

I realise i could limit to a % and use limits based on 0 --> 1 etc. but i would like to display the value.

Is this possible ? Seems like basic enough functionality

0 Replies