Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
I see how that works with the dimensions, however How do I get it to show up in a list box?
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