Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Compare two values for displaying colors in QLIKSENSE

Hi All,

I want to display Bar chart for the below data.

Names
DateValue1Value2
a

1-1-2016

100100
b

1-1-2016

120120
c1-1-2016130120
a1-2-2016100100
b1-2-2016123123
c1-2-2016300300
a1-3-2016120120
b1-3-2016130130
c1-3-2016160150

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   

Tags (1)
1 Solution

Accepted Solutions
brunobertels
Valued Contributor

Re: Compare two values for displaying colors in QLIKSENSE

Hi

if this is what you want :

add this

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

in the color and legend panel by expression

3 Replies
brunobertels
Valued Contributor

Re: Compare two values for displaying colors in QLIKSENSE

Hi

if this is what you want :

add this

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

in the color and legend panel by expression

Re: Compare two values for displaying colors in QLIKSENSE

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

MVP
MVP

Re: Compare two values for displaying colors in QLIKSENSE

HI,

Add this in Color Expression

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


Hope this helps you.


Regards,

Jagan.