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: 
marieclaire
Creator
Creator

KPI in a textbox : color on percentage ?

Hi the community,

I try to design a KPI in text box.

I would like to color a percent value (red if <0 and green if >0).

I have this expression :

=num(

((sum( {<Mois = {$(=Max (Mois))}>}Visites))-(sum( {<Mois = {$(=num(Max (Mois)-1,'00'))}>}Visites)))

/sum( {<Mois = {$(=num(Max (Mois)-1,'00'))}>}Visites)

,'+##0,0%'

)

it gives me :

text box color percent.png

Anybody could tell me how to manage to color the value ?

Thank you,

3 Replies
MK_QSL
MVP
MVP

go to font tab or Text Box Properties

and Select Color and use Conditional color !

marieclaire
Creator
Creator
Author

Hi Manish,

Thank you. I tried this and it does not work :

if(

(

num(

((sum( {<Mois = {$(=Max (Mois))}>}Visites))-(sum( {<Mois = {$(=num(Max (Mois)-1,'00'))}>}Visites)))

/sum( {<Mois = {$(=num(Max (Mois)-1,'00'))}>}Visites)

,'+##0,0%'

) > 0, rgb(255,0,0),rgb(0,128,0))

)

An idea ?

MK_QSL
MVP
MVP

Provide your sample file..