topic Re: Issue in nested if in QlikView

Issue in nested if

Tue, 21 Jul 2015 19:17:28 GMT

Hi,

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]

Regards,

Sachin

Re: Issue in nested if

ramoncova06 — Tue, 21 Jul 2015 20:21:37 GMT

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]

Re: Issue in nested if

Tue, 21 Jul 2015 20:33:27 GMT

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.

Re: Issue in nested if

Qrishna — Tue, 21 Jul 2015 20:34:01 GMT

Try the script in the doc..

output:

Re: Issue in nested if

ramoncova06 — Tue, 21 Jul 2015 20:46:11 GMT

so you want to create a second entry, one per each bucket ?

Re: Issue in nested if

Tue, 21 Jul 2015 20:53:19 GMT

Hi Chaitanya,

Where is the document attached.

Re: Issue in nested if

Tue, 21 Jul 2015 20:53:27 GMT

Yeah

Re: Issue in nested if

Qrishna — Tue, 21 Jul 2015 20:55:23 GMT

its attached.

Re: Issue in nested if

Tue, 21 Jul 2015 21:02:04 GMT

But the requirement is:

For ex when the value is 36 it should come under >10 as well as >31 bucket.

Re: Issue in nested if

Tue, 21 Jul 2015 21:07:40 GMT

But the requirement is:

For ex when the value is 36 it should come under >10 as well as >31 bucket.

Re: Issue in nested if

MarcoWedel — Tue, 21 Jul 2015 21:30:43 GMT

please post sample data with input values and the complete expected result.

thanks

regards

Marco

Re: Issue in nested if

MarcoWedel — Tue, 21 Jul 2015 21:39:26 GMT

please create a complete input/output specification instead of opening new threads for the same question.

Issue in nested if

nested if

thanks

regards

Marco