How to change colour in Qliksense based on a condition ?

[shekhar_analyti]

Hi All ,

How to change the Colour of KPI in Qliksense based on following condition :

1) If    Exp1 > Exp 2  THEN Green

2) If    Exp1 < Exp 2  THEN Red

1) If    Exp1 = Exp 2  THEN Blue

Please attach sample qvf for reference .

Thanks & Regards

Shekar

[shekhar_analyti]

Please help stalwar1‌

[viveksingh]

Hi Shekar,

you have to write multiple if sataements.

If(EXP1>EXP2,RGB(255,0,0),if(EXP1<EXP2,RGB(0,128,0),IF(EXP1=EXP2,(RGB(0,0,255)))))

or else you can also use RED(), GREEN(), BLUE() instead of RGB color codes.

or else you can also enable conditional colors and add limit value for that or you write your own expression in that too.

[shekhar_analyti]

I had already tried , but smthing is getting messed up .. Can you please attach your sample qvf ?

[#5]

Hi Shekhar,

Check the attachment once. Hope it helps.

[shekhar_analyti]

Hi Sandhya ,

Thanks for reply . Actually I was looking for conditional coloring in KPI . I see you have done for Table Values .

Thanks

[Anil_Babu_Samineni]

Can you share dataset to look or may be QVF?

[viveksingh]

Can you post sample QVF?

[shekhar_analyti]

Hi Anil ,

Please find data attached .

I want KPI in qliksense which should give me sum of sale from current date and also show that whether its up or down (by how much )

from previous day sales .

Regards

[buzzy996]

pfa,write ur expression accordingly ur needs.