Compare values in cells

[#1]

Hai all

I am new to Qlikview. I am working on a table. I populated it with right data, calculated expressions etc.

Can someone suggest me how to do this?

I have a 3 sort fields - Region, country , year and year has 2009 and 2010. so there will be 2 records. I want to make value for 2010 Green if it is more than value for 2009 for that region and country else if it is less I need to make it Red. either change the font color or fill the cell with those colors. And later I need to count the number of greens and reds. How can this be done?

Please let me know of any questions.



Thanks a lot..

[john_duffy]

Hello.

You can expand the options on each dimension or expression and set the background or text colour. This can be done by simply assigning a colour (eg. red()) or by entering an expression (eg. if (amount > 10,red(),green()).

Let me know if this helps.

John.

[#3]

Thanks for your reply. Its not based on condition. Its based on value of prior record value

[#4]

I guess I need to use Last function but I am not sure how to use it on a field

[john_duffy]

How about using the above function? Something like if (above(sum(fieldA)) > sum(fieldA),green(),red()).

[#6]

Above may work but its giving error..syntax issue may be

[hector]

hi,

maybe with the first line, above() is null, you need to change this

rgds

[#8]

I am not sure what should I do?

Its like compare value with above and change background to green if more than above else red

[hector]

Hi,

something like this?

rgds

[#10]

wow hector..it looks like i need this..can you please send that expression,