Discussion board where members can get started with QlikView.
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?
Go to Solution.
Use Set NullInterpret = ''; and then IsNull function will work.
Instead of using Isnull(Date1) you should be able to use Len(Date1)=0
if(len(Date1) = 0 or wildmatch(Date1,''),0,Today()-Date1)
Taking a guess here, but have you tried
IF(Date1 = "", today()- DATE, '0')
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. :-)