topic Re: incorrect date format qlikview script in QlikView

incorrect date format qlikview script

capriconuser — Sat, 16 Nov 2024 02:43:18 GMT

i have this script

file_Mapping: MAPPING LOAD Policy_No., date(floor(Policy_Effective_Date_Update)) as Policy_Effective_Date_Update FROM [Mapping_ffile.xlsx] (ooxml, embedded labels, table is [Mapping_ffile]);

and

file_Mapping: LOAD [Policy #], date(Floor(ApplyMap('PSD_Mapping',[Policy #]))) as date_test, FROM Member_file_test.qvd (qvd);

so when i check date_Test file this shows incorrect format like below image

Re: incorrect date format qlikview script

dplr-rn — Fri, 16 Aug 2019 13:01:14 GMT

You may need to format is after you floor it. using Date function

Also i would double check the format the format of the timestamp from excel. Load it directly into a table without floor and check the format and data type you are getting

Re: incorrect date format qlikview script

capriconuser — Tue, 20 Aug 2019 04:32:12 GMT

i did all that but nothing helps i chnage the format of date in properties and also in excel but sam thing appears

Re: incorrect date format qlikview script

jonathandienst — Tue, 20 Aug 2019 05:15:08 GMT

What is the format of the date field in the source Excel file?

Re: incorrect date format qlikview script

capriconuser — Tue, 20 Aug 2019 05:17:07 GMT

DD-MMM-YYYY

Re: incorrect date format qlikview script

ChennaiahNallani — Tue, 20 Aug 2019 06:29:27 GMT

file_Mapping: MAPPING LOAD Policy_No., date(date#(floor(Policy_Effective_Date_Update),'dd-mmm-yyyy'),'dd-mmm-yyyy') as Policy_Effective_Date_Update FROM [Mapping_ffile.xlsx] (ooxml, embedded labels, table is [Mapping_ffile]);

Re: incorrect date format qlikview script

capriconuser — Tue, 20 Aug 2019 07:49:36 GMT

this shows an error

MAPPING requires 2-column input

Re: incorrect date format qlikview script

Brett_Bleess — Wed, 28 Aug 2019 21:17:14 GMT

Couple of Design Blog posts that may be of some use to check your logic etc.

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-as-an-Alternative-to-Joining/ba-p/1473454

You can use the following link to search yourself in this area as well:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett