Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When i load data from excel and the cell is empty it shows in Qlikview a blank cell instead of being null.
In my application im using a pivot table with the expression IF(ISNULL(Date1), today() - DATE, '0'), this won't work, there is no outcome in my pivot table.
Does somebody know how i can solve this?
Use Set NullInterpret = ''; and then IsNull function will work.
Instead of using Isnull(Date1) you should be able to use Len(Date1)=0
Try this,
if(len(Date1) = 0 or wildmatch(Date1,''),0,Today()-Date1)
Regards,
Kaushik Solanki
Taking a guess here, but have you tried
IF(Date1 = "", today()- DATE, '0')
?
Use Set NullInterpret = ''; and then IsNull function will work.
Wow, many respones in such a short time. They all probably would have worked, so thanks all of you!
I used the answer from KStreak S as the solution, thanks. 🙂