Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mikegauntlett
New Contributor

Nested IF

Hi I have the below

=IF(IsNull(Status),(IF(IsNull(AARO_Booking_Period),'R0','R1')),Status)

The R1 gets produced but the R0 is failing.

I am attempting to say

Anything where both the status and the Aaro Booking period are null = R0

where only the the status is null = R1

all others = Status

Any Ideas

3 Replies
MVP
MVP

Re: Nested IF

May be try with Len(Trim())

=If(Len(Trim(Status)) = 0,

  If(Len(Trim(AARO_Booking_Period)) = 0, 'R0', 'R1'), Status)

mikegauntlett
New Contributor

Re: Nested IF

Fraid not R0 is still not getting produced, i have checked the data and there are actual cases where R0 should be.

MVP
MVP

Re: Nested IF

Would you be able to share some raw data to test this out?

Community Browser