Compare two values for displaying colors in QLIKSENSE

[#1]

Hi All,

I want to display Bar chart for the below data.

Names	Date	Value1	Value2
a	1-1-2016	100	100
b	1-1-2016	120	120
c	1-1-2016	130	120
a	1-2-2016	100	100
b	1-2-2016	123	123
c	1-2-2016	300	300
a	1-3-2016	120	120
b	1-3-2016	130	130
c	1-3-2016	160	150

Now i want to display BAR Chart in Qliksense for the above data. I required value1 and value2 bars as measures and date as dimesnion.

Here if value1 and value2 are same the bar to be display in GREEN color. If value1 and Value2 are not same after then bar should be display in RED Color.

Please help me on this.

Thanks

Avinash  Avinashelite   jagan   

[brunobertels · Accepted solution]

Hi

if this is what you want :

add this

if(sum(Value1)=sum(Value2),green(),lightred())

in the color and legend panel by expression

[avinashelite]

Please follow the steps mentioned by brunobertels‌ that should work . If your able to achieve the same please let us know will help you out with the same

[jagan]

HI,

Add this in Color Expression

If(Sum(Value1) = Sum(Value2), Green(), Red())

Hope this helps you.

Regards,

Jagan.