topic Value greater than below in QlikView

Value greater than below

Mon, 14 May 2012 07:06:24 GMT

Hi All,

Please help me for the requirement which I have.

Please find the attached application.

I want the background color of row as green which is greater than row below it.

For eg. In attached qvw

1) First Row 155 is greater than Row below which is 123 , so background of 155 should be green.

2) Now for Row no 3 i.e value 110 which is less than the row below it .ie 119 , background of row 110 should be red.

Mon, 14 May 2012 08:01:36 GMT

Hi,

You can try the function Above in the background color of the expression.

So you could use something like this:

=if(avg(Result)>Above(avg(Result),-1),green(),red())

Hope that helps.

its_anandrjs — Mon, 14 May 2012 08:16:52 GMT

Hi,

Use some thing like this in Background color expression

if(Above(avg(Result)) > Below(Avg(Result)) ,Red(),Green())

Regards,

Anand