Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
if(isnull(ActualDaysDifference)
or
if(len(ActualDaysDifference)=0
These don't bring in all the fields with 0 AND that are null though, surely it's just one or the other?
if(isnull(ActualDaysDifference) or ActualDaysDifference=0 , ...
or
if(len(ActualDaysDifference)=0 or ActualDaysDifference=0 , ...
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