1 Reply Latest reply: Oct 20, 2015 12:48 AM by Robert Mika RSS

    Time Sorting

    Chay Him

      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)