topic Listbox Date Error in QlikView

Listbox Date Error

Tue, 14 Feb 2012 11:32:10 GMT

Hi Guys,

i have a specific problem with the date format in a report and hope you have an idea to solve this.

The list box for the date looks as follows:

The last day imported was the 13th february. After this date QlikView continues the list box with the figures above. 40953 is the code for 14.02.2012 and so on, but how can i tell it, that it has to show it in the right format and not in wild figures, or that it ends after the last imported date?

Anyone who has an idea?

Thanks in advance!

Listbox Date Error

jagan — Tue, 14 Feb 2012 11:35:48 GMT

Hi,

List Box -> Properties -> Number tab - > Select Override Document Settings -> Select Date

I think this fixes the issue.

Regards,

Jagan.

Listbox Date Error

Tue, 14 Feb 2012 11:36:54 GMT

Hi,

Have you tried DATE or DATE# in your load script?

Regards,

sebablum

Listbox Date Error

swuehl — Tue, 14 Feb 2012 11:37:39 GMT

I assume that it's a loading issue. Are you loading from excel file? I have seen something like this if the cell formatting in excel changes in column.

If so, either correct the excel formatting or use alt() function to parse in different formats. Please have a look at the alt() function in the Help.

Hope this helps,

Stefan

Listbox Date Error

Tue, 14 Feb 2012 11:41:49 GMT

Hi Guys, thank you very much for the fast reply.

Jagan's proposal works!

Thanks!