topic complicated if statement in QlikView

complicated if statement

Mon, 02 Sep 2013 13:23:41 GMT

Hello community

I have an 'if' statement that is giving me hell, i need your help.

We have the following fields:

[Boys]

[Girls]

[#No]

[Children]

The [Children ] can have >1 [#No].

The original expression is :

((sum([Boys])-sum([Girls]))* 0.90)-avg([Boys])

Now the 'if ' statement is supposed to be something like:

If ([#No]>1,((sum([Boys])-sum([Girls]))* 0.90)-avg([Boys]),(((sum([Boys])* 0.90)-avg([Boys])))

Dimension [Children]

Some how im getting the wrong answer when [Children] has only 1 [#No]

Please help.

Re: complicated if statement

jagan — Mon, 02 Sep 2013 13:45:45 GMT

Hi,

Can you attach the sample file.

Regards,

jagan.

Re: complicated if statement

michael_maeuser — Mon, 02 Sep 2013 13:55:25 GMT

try this

If ([#No]>1,(sum([Boys])-sum([Girls]))* 0.90)-avg([Boys]),(((sum([Boys])* 0.90)-avg([Boys])))

Re: complicated if statement

Mon, 02 Sep 2013 14:01:13 GMT

Hi Jagan Moan

Unfortunately I cannot attach the sample file.

I think the problem could be that i must put the 'sum' before the 'if' in the expression....

Re: complicated if statement

michael_maeuser — Mon, 02 Sep 2013 14:04:13 GMT

sorry mistake

If ([#No]>1,(sum([Boys])-sum([Girls]))* 0.90-avg([Boys]),sum([Boys])* 0.90-avg([Boys]))

Re: complicated if statement

Mon, 02 Sep 2013 14:05:10 GMT

Hi Michael

Im getting a syntax error

Re: complicated if statement

michael_maeuser — Mon, 02 Sep 2013 14:07:53 GMT

what kind of value are in the field children?

Re: complicated if statement

Mon, 02 Sep 2013 14:12:40 GMT

numbes 1 to 30

Re: complicated if statement

Mon, 02 Sep 2013 14:13:28 GMT

The second expressiion seems to be working Michael. I just want to verify this and I'll let you know

Re: complicated if statement

michael_maeuser — Tue, 03 Sep 2013 08:00:39 GMT

have you checked if the expression works?

Re: complicated if statement

Tue, 03 Sep 2013 12:01:36 GMT

Thank you Michael, It worked perfectly.