Discussion Board for collaboration on QlikView Scripting.
I have an 'if' statement that is giving me hell, i need your help.
We have the following fields:
The [Children ] can have >1 [#No].
The original expression is :
Now the 'if ' statement is supposed to be something like:
Some how im getting the wrong answer when [Children] has only 1 [#No]
Go to Solution.
have you checked if the expression works?
Can you attach the sample file.
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....
Im getting a syntax error
what kind of value are in the field children?
numbes 1 to 30
The second expressiion seems to be working Michael. I just want to verify this and I'll let you know