Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excell cells are blank instead of NULL

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?

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Taking a guess here, but have you tried

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

?

Not applicable
Author

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

Not applicable
Author

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