Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue in nested if

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

2 Replies
Nicole-Smith

You're missing conditions on the second and third ifs:

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]

MarcoWedel

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

nested if

Issue in nested if

Issue in nested if

Issue in nested if

thanks

regards

Marco