topic Re: Date issue in QlikView

Date issue

Mon, 10 Dec 2012 13:52:42 GMT

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.

Re: Date issue

MayilVahanan — Mon, 10 Dec 2012 13:59:31 GMT

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

Re: Date issue

Mon, 10 Dec 2012 14:08:52 GMT

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

Re: Date issue

jonathandienst — Mon, 10 Dec 2012 14:19:34 GMT

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