Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Time Sorting

I am trying to sort my bar chart by time, but somehow Qlik Sense is messing up the sorting.

2.JPG

If I were to show only the HH numbers, Qlik Sense sorts it perfectly. However, when I input & '00hrs' into the function such that it shows '1100hrs' instead of just '11', the order gets jumbled up.

Is there any way for me to write the script?

Data input is via a dimension called "TIME IN" in the format HH:MM:SS TT, but in my chart, I am trying to show only HH TT (e.g. 11AM)

1 Reply
robert_mika
Master III
Master III

I assume that because your format will change to string .

Did you try to use Sort Numerically in the Sorting options?

If that does not help look at:

How to use- Dual()

Feeling Qlikngry?

How To /Missing Manual(18 articles)