Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fkeuroglian
Honored Contributor

KPI object dinamic color

Hi Expert

i have a qvf wiht a kpi object that compare this month vs last year same month

i put color but i want to put colors depends on the values

example

if the current month is better than the same month last year, paint in green, if not paint in red

how we manage the colors dinamic?

thank you a lot

Fernando

attached de qvf

1 Solution

Accepted Solutions
vigneshvs
Contributor II

Re: KPI object dinamic color

Hi,

PFA.. Hope this helps.

Thanks,

Vignesh

3 Replies
vigneshvs
Contributor II

Re: KPI object dinamic color

Hi,

PFA.. Hope this helps.

Thanks,

Vignesh

rsw
Contributor II

Re: KPI object dinamic color

Within the properties of the measure there is a switch to enable "Conditional Colours". You will need to switch this on and then you will see an "add limit" button. Clicking that will give you an option to set a limit with different colour options, the limit can be determined by an expression. In your case you could simply set the colours to be green on one side and red on the other and the expression being a simple subtraction between the current month expression and the 12 month ago expression.

Rod

fkeuroglian
Honored Contributor

Re: KPI object dinamic color

Thank you Vignesh

Community Browser