topic Re: IF and Null statement in QlikView

IF and Null statement

khaycock — Sat, 16 Nov 2024 03:00:28 GMT

I have a statement that I am looking to display the 0 and nulls if they are present but I can't get the IF statement to show the nulls.

It's quite a beefy IF statement but if the field ActualDaysDifference is 0 or blank, I want it to keep that. It works for 0 but not for the blanks so I'm not sure what to do?

if(ActualDaysDifference = ' ' or '0', ActualDaysDifference,if(ActualDeliveryDate<PlannedDeliveryDate, networkdays(ActualDeliveryDate,PlannedDeliveryDate)*-1, WorkingDaysDifference)) AS DaysDifferenceAgain

Re: IF and Null statement

m_woolf — Mon, 15 Jul 2019 11:47:32 GMT

Try:

if(isnull(ActualDaysDifference)

if(len(ActualDaysDifference)=0

Re: IF and Null statement

khaycock — Mon, 15 Jul 2019 11:52:42 GMT

These don't bring in all the fields with 0 AND that are null though, surely it's just one or the other?

Re: IF and Null statement

m_woolf — Mon, 15 Jul 2019 12:19:57 GMT

if(isnull(ActualDaysDifference) or ActualDaysDifference=0 , ...

if(len(ActualDaysDifference)=0 or ActualDaysDifference=0 , ...

Re: IF and Null statement

Brett_Bleess — Wed, 07 Aug 2019 19:44:48 GMT

Did Mike's final post help you resolve things? If so, please be sure to give him credit by clicking the Accept as Solution button on his post.

Here are some additional links that may help a little as well:

https://community.qlik.com/t5/Qlik-Design-Blog/Finding-NULL/ba-p/1474279

https://community.qlik.com/t5/Qlik-Design-Blog/NULL-The-Invisible-Nothing/ba-p/1467674

Regards,
Brett