Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
if this is what you want :
add this
if(sum(Value1)=sum(Value2),green(),lightred())
in the color and legend panel by expression
Hi
if this is what you want :
add this
if(sum(Value1)=sum(Value2),green(),lightred())
in the color and legend panel by expression
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
HI,
Add this in Color Expression
If(Sum(Value1) = Sum(Value2), Green(), Red())
Hope this helps you.
Regards,
Jagan.