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
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 III
Contributor III
‎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
336 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

328 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

 

329 Views
0 Likes
RobinTMavhu
Contributor III
Contributor III
‎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
320 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

311 Views