topic Re: Load dates from Excel in QlikView

Load dates from Excel

chriys1337 — Mon, 22 May 2017 21:37:16 GMT

Hi,

I am loading some dates from an Excel, which are formatted as date in Excel and represented like "01.05.2017".

When I load my crosstable in QlikView the date field displays numbers, e.g. 42877 - that's fine till then, BUT they are recognized as a text, they are stated on the left side of the field in the frontend.

And formatting in the script with date(date#(Date_Field,'DD.MM.YYYY'),'DD.MM.YYYY') as Dates_New

does not help anything, these numbers are still shown on the leftside, instead of the right.

Can anybody help please?

Chris

Re: Load dates from Excel

Digvijay_Singh — Mon, 22 May 2017 22:20:09 GMT

Maybe try this, looks like they are date numbers while importing -

date(num(Date_Field),'DD.MM.YYYY') as Dates_New

Re: Load dates from Excel

Anil_Babu_Samineni — Tue, 23 May 2017 04:34:44 GMT

Are you doing this in Cross Table? Can you confirm this, If so, Please mention how script looks like

Please have a look Re: Crosstable numeric values

Re: Load dates from Excel

prma7799 — Tue, 23 May 2017 04:51:52 GMT

Please share some sample data.

Re: Load dates from Excel

qlikview979 — Tue, 23 May 2017 04:52:39 GMT

Hi,

please share the sample file.