topic Need help in IF statement in QlikView

Need help in IF statement

Thu, 25 Feb 2010 10:52:59 GMT

Hi All,

I need a help from you. I have 4 images. 1.jpg,2.jpg,3.jpg,4.jpg

I have current week value, last week value and the budget value.

If the (current week value is > last week value ) and current week value is greater than budget value then 1.jpg

If the (current week value is > last week value ) and current week value is less than budget value then 2.jpg

If the (current week value is < last week value ) and current week value is greater than budget value then 3.jpg

If the (current week value is < last week value ) and current week value is less than budget value then 4.jpg

How can i do this in single IF statement?

Any help is appreciated.

Thanks,

Raghu.

Anonymous — Thu, 25 Feb 2010 11:13:33 GMT

did not test this but think it should be something like this:

if (current > last,

if(current > budget, 1.jpg, 2.jpg),

if(current > budget, 3.jpg, 4.jpg)

)

Anita

stephencredmond — Thu, 25 Feb 2010 11:30:39 GMT

Great QlikView! Minimize the number of entries.

Looking at things in a different way will often reveal a better approach to the one that we thought we needed to use.

Stephen