Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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