Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

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
Anonymous
Not applicable

Hi,

PFA.. Hope this helps.

Thanks,

Vignesh

View solution in original post

3 Replies
Anonymous
Not applicable

Hi,

PFA.. Hope this helps.

Thanks,

Vignesh

Anonymous
Not applicable

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
Partner - Master
Partner - Master
Author

Thank you Vignesh