topic Re: Timestamp Issue in QlikView

Timestamp Issue

Sat, 16 May 2015 12:18:32 GMT

Hi All,

I am loading data from an xlsx file. There is a column present in the file which has values in datetime format such as 1/3/2015 17:45.

While loading it in qlikview, I am getting it in number format.

How do I get the timestamp format in which the data is present in the excel into the specific column in the script?

Thanks,

Asma

Re: Timestamp Issue

ToniKautto — Sat, 16 May 2015 12:25:34 GMT

Use the Timestamp() function to format the number into a timestamp. By the below principle.

LOAD

Timestamp(MyTimestampField) AS MyTimestamp

FROM myfile.xlsx

If you need more detailed help a sample XLSX file and QVW file would make it a lot easier to understand what happens in your scenario.

Re: Timestamp Issue

PrashantSangle — Sat, 16 May 2015 12:34:22 GMT

Hi,

Try any of the below two

Timestamp(fieldName,'DD/MM/YYYY hh:mm')

Date(fieldName,'DD/MM/YYYY hh:mm')

Regards

Re: Timestamp Issue

Sat, 16 May 2015 12:50:42 GMT

It is worth mentioning that all datetimes in qlikview is represented by floating point number. the whole number is the days passed since 31 December 1899 and the fractional value is the time.

using the previously mentioned function will put them in the format we know.