Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please help stalwar1
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.
I had already tried , but smthing is getting messed up .. Can you please attach your sample qvf ?
Hi Shekhar,
Check the attachment once. Hope it helps.
Hi Sandhya ,
Thanks for reply . Actually I was looking for conditional coloring in KPI . I see you have done for Table Values .
Thanks
Can you share dataset to look or may be QVF?
Can you post sample QVF?
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
pfa,write ur expression accordingly ur needs.