Excell cells are blank instead of NULL

[#1]

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?

[Anonymous]

Instead of using Isnull(Date1) you should be able to use Len(Date1)=0

[kaushiknsolanki]

Try this,

     if(len(Date1) = 0 or wildmatch(Date1,''),0,Today()-Date1)

Regards,

Kaushik Solanki

[#4]

Taking a guess here, but have you tried

IF(Date1 = "", today()- DATE, '0')

?

[#5 · Accepted solution]

Use Set NullInterpret = ''; and then IsNull function will work.

[#6]

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. 🙂