Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Excell cells are blank instead of NULL

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

5 Replies
jsn
Honored Contributor

Re: Excell cells are blank instead of NULL

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

Re: Excell cells are blank instead of NULL

Try this,

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

Regards,

Kaushik Solanki

Not applicable

Re: Excell cells are blank instead of NULL

Taking a guess here, but have you tried

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

?

Not applicable

Re: Excell cells are blank instead of NULL

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

Not applicable

Re: Excell cells are blank instead of NULL

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. :-)