Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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: 
Not applicable
‎2017-05-30 05:18 AM

Getting Date Part from specific text format

Hi,

I have dimension that contains values as below text format.Is there logic to get date part from the below text.

abc.def_APR_07_2017_11H_18m_47s

I need to convert APR_07_2017_11H_18m_47s to date format.Is it possible to do in qliksense

2,211 Views
0 Likes
10 Replies
Not applicable
‎2017-05-31 10:07 AM
Author

In response to OmarBenSalem

Hi,

I used same above logic that you suggested.But am not able to see time field under fields tab . I can only see below fields and the data is also incomplete.

Do I need to change any settings to get the time field also?

356 Views
0 Likes