Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jipprinsen
Contributor
Contributor

Importing date format

Hello,

I have two tables using a different time format. One uses "YYYY_WW" the other uses a standard "DD-MM-YYYY". When loading the data Qlik Sense has no problem with the second format, but I can't find a way to import the "YYYY_WW" format as a date usable in Qlik Sense. Can anyone help me with this?

1 Solution

Accepted Solutions
rubenmarin

2 Replies
isingh30
Specialist
Specialist

Can you share some sample?

rubenmarin

Hi maybe with::

MakeWeekDate(Subfield(DateField,'_',1), Subfield(DateField,'_',2))

https://help.qlik.com/en-US/sense-cloud/Subsystems/CloudHub/Content/Scripting/DateAndTimeFunctions/m...