topic Re: Date variable looking like a float value in QlikView

Date variable looking like a float value

Tue, 16 Feb 2016 16:05:06 GMT

Hi,

In my report I have two variable that are set from a calendar. Sometime when I select dates, they ends up like this :

42456.1234 and some other time like this 43245. Why does those value is float ? The decimal part represent what ? Hours ? This is causing issues with my report.

On the other hand, I have others calendar that store only Integer in the variable. Someone can explain to me, how this happen ?

Thank you.

Daniel

Re: Date variable looking like a float value

sunny_talwar — Tue, 16 Feb 2016 16:46:36 GMT

Not sure how you are creating them, but yes, the decimal parts represents time information. Would you be able to share how are you creating them to see what is going on?

Re: Date variable looking like a float value

marcus_sommer — Tue, 16 Feb 2016 16:48:36 GMT

Yes it meant it's then not a date else a timestamp with hours, minutes and so on - you could solve it by loading these date-field with:

date(floor(YourDateField), 'YourFormatPattern') as YourDateField

- Marcus

Re: Date variable looking like a float value

Tue, 16 Feb 2016 16:59:19 GMT

Of course:

This when I load from the QVD:

This the calendar configuration:

This is how the variables looks like:

Is this enough for you ?

Thank you.

Re: Date variable looking like a float value

Tue, 16 Feb 2016 17:10:14 GMT

Thank you.

Re: Date variable looking like a float value

sunny_talwar — Tue, 16 Feb 2016 17:10:49 GMT

Can you try loading OrderDate like this:

Date(Floor(OrderDate)) as OrderDate