Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

incorrect date format qlikview script

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 

 

clipboard_image_0.png

Labels (1)
7 Replies
dplr-rn
Partner - Master III
Partner - Master III

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

capriconuser
Creator
Creator
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
capriconuser
Creator
Creator
Author

DD-MMM-YYYY

ChennaiahNallani
Creator III
Creator III

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]);
capriconuser
Creator
Creator
Author

this shows an error 

 

MAPPING requires 2-column input

Brett_Bleess
Employee
Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.