Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe try this, looks like they are date numbers while importing -
date(num(Date_Field),'DD.MM.YYYY') as Dates_New
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
Please share some sample data.
Hi,
please share the sample file.