Date issue

[#1]

I am using the Master Calendar which works awesome, however when I have a date field that is null I can't get that to showup in the qlikview.  How can I get a null value to show up.  For example, the date field will contain many dates, but some rows have a null in the date field and I still want to see those rows.

Hope this makes sense, thanks in advance.

[MayilVahanan]

HI

Check the uncheck suppress null value in dimension tab and suppress missing in presentation tab , and check show all values in dimension tab.

Hope it helps

[#3]

I see how that works with the dimensions, however How do I get it to show up in a list box?

[jonathandienst · Accepted solution]

Hi

Nulls cannot be shown in a list box - in the QV world they are "nothing" and cannot be selected. If you need to override this behaviour, use NULLASVALUE in your load script. Assuming your date field is called [Date], add the following line (I think before the load statement?):

NULLASVALUE [Date];

This will convert nulls to something like an empty string, which is selectable and will show up in a list box

Hope that helps

Jonathan