topic Re: is it possible to compare two dimensions value ?? in QlikView

is it possible to compare two dimensions value ??

sibideepak — Thu, 04 Sep 2014 10:18:29 GMT

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

Re: is it possible to compare two dimensions value ??

tresB — Thu, 04 Sep 2014 10:30:08 GMT

Try like:

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

Similarly you can use Below() as well.

See attached sample too.

Re: is it possible to compare two dimensions value ??

sibideepak — Thu, 04 Sep 2014 11:07:20 GMT

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 .

Re: is it possible to compare two dimensions value ??

tresB — Thu, 04 Sep 2014 11:11:15 GMT

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.

Re: is it possible to compare two dimensions value ??

sibideepak — Thu, 04 Sep 2014 11:42:33 GMT

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

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

Re: is it possible to compare two dimensions value ??

tresB — Thu, 04 Sep 2014 11:53:51 GMT

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

Re: is it possible to compare two dimensions value ??

sibideepak — Thu, 04 Sep 2014 12:11:24 GMT

Thanks ,

I tried and it works