topic Re: Nested if condition in expressions in QlikView

Nested if condition in expressions

Tue, 21 Oct 2014 06:14:21 GMT

Hi,

I am trying to accomplish a nested if condition to an expression but i am not able to successfully implement it. I am comparing a sales trend, and my expression is given below,

if(((Sum({$<Year = {$(=Only(Year ))}>}[Net Sales])) - (Sum({$<Year = {$(=Only(Year)-1)}>}[Net Sales]))) = 0,'qmem://<bundled>/BuiltIn/arrow_e_y.png', if(((Sum({$<Year = {$(=Only(Year ))}>}[Net Sales])) - (Sum({$<Year = {$(=Only(Year )-1)}>}[Net Sales]))) > 0,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

I am trying to implement image to this expression. characters starting with "gmem" are nothing but the link to images. If I use a single if condition, it works perfectly fine. But if I want to have three possibilities (using 2 if conditions), then it is not working. Please help.

Thanks,

Sivacharan

Re: Nested if condition in expressions

tresB — Tue, 21 Oct 2014 06:20:45 GMT

Perhaps a parenthesis issue. Put one more closing parenthesis at the end and try.

Re: Nested if condition in expressions

jagan — Tue, 21 Oct 2014 06:21:26 GMT

Hi,

Check this

if(Sum({$<Year = {$(=Max(Year))}>}[Net Sales]) - Sum({$<Year = {$(=Max(Year)-1)}>}[Net Sales]) = 0, 'qmem://<bundled>/BuiltIn/arrow_e_y.png',

if(Sum({$<Year = {$(=Max(Year ))}>}[Net Sales]) - Sum({$<Year = {$(=Max(Year)-1)}>}[Net Sales]) > 0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png'))

Hope this helps you.

Regards,

jagan.

Re: Nested if condition in expressions

Tue, 21 Oct 2014 06:53:08 GMT

Thanks for the quick reply.

I Actually want to calculate the sum for the currently selected year - previous year . like if I select year 2009, then it should calculate for sales of 2009 - sales of 2008 or vice versa. Believe max won't work the way I want..

Re: Nested if condition in expressions

jagan — Tue, 21 Oct 2014 07:01:54 GMT

Hi,

I you select 2009, then Max(Year) is 2009 and Max(Year) -1 is 2008, this is what I am doing, if you do not give Max() and use Only(), you will get null value when no year is selected. That is why I used Max(), if Year is always selected one then you can use Only().

Is above expression working? Did you checked?

Hope this helps you.

Regards,

Jagan.

Re: Nested if condition in expressions

d_pranskus — Tue, 21 Oct 2014 11:26:03 GMT

I would suggest to use the following expression

=PICK(SIGN(SUM({$<Year = {$(=Max(Year))}>}[Net Sales]) - SUM({$<Year = {$(=Max(Year)-1)}>}[Net Sales])) + 2, 'qmem://<bundled>/BuiltIn/arrow_s_r.png', 'qmem://<bundled>/BuiltIn/arrow_e_y.png', 'qmem://<bundled>/BuiltIn/arrow_n_g.png')

Re: Nested if condition in expressions

Anonymous — Tue, 21 Oct 2014 14:12:33 GMT

if(Sum({$<Year = {$(=Only(Year ))}>}[Net Sales]) - Sum({$<Year = {$(=Only(Year)-1)}>}[Net Sales]) = 0,'qmem://<bundled>/BuiltIn/arrow_e_y.png',

if(Sum({$<Year = {$(=Only(Year ))}>}[Net Sales]) - Sum({$<Year = {$(=Only(Year )-1)}>}[Net Sales]) > 0,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png'))

Re: Nested if condition in expressions

Wed, 29 Oct 2014 05:06:14 GMT

Thanks for pitching in the issue with my expression.. Adding the parenthesis at the end did work.. So dumb of me

Re: Nested if condition in expressions

Wed, 29 Oct 2014 05:09:07 GMT

Yep, it does work. I missed the parenthesis at the end.. Max also works fine.. However, I have a condition to display the column only if there is one selection is made.. But this is a good learning to display the max selection when I dont use that condition.. Thanks

Re: Nested if condition in expressions

Wed, 29 Oct 2014 05:10:06 GMT

This too does work. Thanks