Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RobinTMavhu
Contributor II
Contributor II
‎2024-03-12 10:12 AM

Date Conversion

SOS. How can l can convert a date showing as 20240228140000 (yyyymmddhh24miss) into a proper date that can be interpreted by Qlik as a dimension in years, month, week and day. It is currently being interpreted as a string.

Labels (4)
Labels
291 Views
0 Likes
1 Solution

Accepted Solutions
Clement15
Creator III
Creator III
‎2024-03-12 10:17 AM

Hello, here's what you can do

Clement15_0-1710253104953.pngClement15_1-1710253117597.png

 

View solution in original post

283 Views
0 Likes
3 Replies
Clement15
Creator III
Creator III
‎2024-03-12 10:17 AM

Hello, here's what you can do

Clement15_0-1710253104953.pngClement15_1-1710253117597.png

 

284 Views
0 Likes
RobinTMavhu
Contributor II
Contributor II
‎2024-03-12 10:25 AM
Author

In response to Clement15

How can l convert it using the calculated field option? my data set has date column in that form which l need to convert using a calculated field?

Preview file
17 KB
275 Views
0 Likes
Clement15
Creator III
Creator III
‎2024-03-12 10:31 AM

In response to RobinTMavhu

Sorry, but I don't quite understand your expectations

266 Views