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
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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: 
panwipa2528
Contributor III
Contributor III
‎2018-01-31 04:47 AM

How to sort period time (Text)?

I have data sort as attach file and need result same as photo

Sort_Sample.qvw
80 KB
12 KB
1,019 Views
0 Likes
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP
‎2018-02-02 07:13 AM

In response to panwipa2528

May be sort using this expression

Date#(Trim(SubField(Period, '-', -1)), 'DD MMM')


Capture.PNG

View solution in original post

Sort_Sample2.qvw
874 Views
0 Likes
4 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2018-01-31 05:05 AM

Hi,

Check the application.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Sort_Sample.qvw
874 Views
panwipa2528
Contributor III
Contributor III
‎2018-01-31 10:34 PM
Author

In response to kaushiknsolanki

When I have data like attach file, please help me again. _/\_

85 KB
Sort_Sample2.qvw
874 Views
0 Likes
panwipa2528
Contributor III
Contributor III
‎2018-02-02 04:19 AM
Author

In response to panwipa2528

stalwar1‌ Can you help me?

874 Views
0 Likes
sunny_talwar
MVP
MVP
‎2018-02-02 07:13 AM

In response to panwipa2528

May be sort using this expression

Date#(Trim(SubField(Period, '-', -1)), 'DD MMM')


Capture.PNG

Sort_Sample2.qvw
875 Views
0 Likes