Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bdunphy
New 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

Tags (2)