This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Can someone please help me with this nested if condition in the script.
I want to categorize these days into four sub groups.
i.e., >10 , >31, >61, >91 I wrote the if condition but its failing in some cases.
if([Days Past Due] >91, '>91', if([Days Past Due] ,'>61', if([Days Past Due] ,'>31', if([Days Past Due] >10 ,'>10',null())))) as [Days Past Due Range]
you are missing a couple of values in your if's
If([Days Past Due] >91, '>91', if([Days Past Due] >61,'>61', if([Days Past Due] > 31,'>31', if([Days Past Due] >10 ,'>10',null())))) as [Days Past Due Range]
Ramon, sorry about the typo, but the requirement is, if the [Days Past Due] value is 32. It should come under the '>10' as well as '>31' bucket. Which won't happen as per the above if condition.
Try the script in the doc..
so you want to create a second entry, one per each bucket ?
Where is the document attached.
But the requirement is:
For ex when the value is 36 it should come under >10 as well as >31 bucket.