is it possible to compare two dimensions value ??

[sibideepak]

Hi ,

Say for example if hav bar chart with month as dimension

and sales as measures ..

I want to compare sales each month with previous month and

change color (for example green,red)...

help me.

Thanks in advance,

Deepak Sibi

[tresB · Accepted solution]

Try like:

=If(Above(Sum(Measure))>Sum(Measure), Green(), Red())            // background color expression

Similarly you can use Below() as well.

See attached sample too.

[sibideepak]

Thanks tresesco ,

Its working..

Actually i dont understand how it works ..

can you explain a bit ..??

And another doubt .. it s not properly working on line chart...

i.e) if line moves down it should appear red .

[tresB]

Above() - as the name says - it gets the value(expression here) of the earlier row. Then, rest part is simple comparison might not require explanation. For details, please refer help or reference manual.

[sibideepak]

And while applying  it s not properly working on line chart...

i.e) if line moves down it should appear red .but not

[tresB]

Try to share your qvw with sample data. See: Preparing examples for Upload - Reduction and D... | Qlik Community

[sibideepak]

Thanks ,

I tried and it works