topic Re: Nested IF in App Development https://community.qlik.com/t5/App-Development/Nested-IF/m-p/5812#M459 <HTML><HEAD></HEAD><BODY><P>Would you be able to share some raw data to test this out?</P></BODY></HTML> Tue, 23 Jan 2018 16:42:11 GMT sunny_talwar 2018-01-23T16:42:11Z Nested IF https://community.qlik.com/t5/App-Development/Nested-IF/m-p/5809#M456 <HTML><HEAD></HEAD><BODY><P>Hi I have the below </P><P></P><P>=IF(IsNull(Status),(IF(IsNull(AARO_Booking_Period),'R0','R1')),Status)</P><P></P><P>The R1 gets produced but the R0 is failing. </P><P></P><P>I am attempting to say </P><P></P><P>Anything where both the status and the Aaro Booking period are null = R0 </P><P>where only the the status is null = R1 </P><P>all others = Status</P><P></P><P>Any Ideas</P></BODY></HTML> Tue, 23 Jan 2018 16:20:02 GMT https://community.qlik.com/t5/App-Development/Nested-IF/m-p/5809#M456 mikegauntlett 2018-01-23T16:20:02Z Re: Nested IF https://community.qlik.com/t5/App-Development/Nested-IF/m-p/5810#M457 <HTML><HEAD></HEAD><BODY><P>May be try with Len(Trim())</P><P></P><P><STRONG style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=If(Len(Trim(Status)) = 0,</STRONG></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>&nbsp; If(Len(Trim(AARO_Booking_Period)) = 0, 'R0', 'R1'), Status)</STRONG></SPAN></P></BODY></HTML> Tue, 23 Jan 2018 16:22:15 GMT https://community.qlik.com/t5/App-Development/Nested-IF/m-p/5810#M457 sunny_talwar 2018-01-23T16:22:15Z Re: Nested IF https://community.qlik.com/t5/App-Development/Nested-IF/m-p/5811#M458 <HTML><HEAD></HEAD><BODY><P>Fraid not R0 is still not getting produced, i have checked the data and there are actual cases where R0 should be.</P></BODY></HTML> Tue, 23 Jan 2018 16:25:28 GMT https://community.qlik.com/t5/App-Development/Nested-IF/m-p/5811#M458 mikegauntlett 2018-01-23T16:25:28Z Re: Nested IF https://community.qlik.com/t5/App-Development/Nested-IF/m-p/5812#M459 <HTML><HEAD></HEAD><BODY><P>Would you be able to share some raw data to test this out?</P></BODY></HTML> Tue, 23 Jan 2018 16:42:11 GMT https://community.qlik.com/t5/App-Development/Nested-IF/m-p/5812#M459 sunny_talwar 2018-01-23T16:42:11Z