Discussion board where members can get started with QlikView.
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
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 , ...
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: