topic Re: Time Sorting in App Development https://community.qlik.com/t5/App-Development/Time-Sorting/m-p/926342#M12780 <HTML><HEAD></HEAD><BODY><P>I assume that because your format will change to string .</P><P>Did you try to use Sort Numerically in the Sorting options?</P><P>If that does not help look at:</P><P><A href="https://community.qlik.com/docs/DOC-8106">How to use- Dual()</A></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(18 articles)</A></P></BODY></HTML> Tue, 20 Oct 2015 04:48:08 GMT robert_mika 2015-10-20T04:48:08Z Time Sorting https://community.qlik.com/t5/App-Development/Time-Sorting/m-p/926341#M12779 <HTML><HEAD></HEAD><BODY><P>I am trying to sort my bar chart by time, but somehow Qlik Sense is messing up the sorting.</P><P></P><P><IMG alt="2.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/102497_2.JPG" style="height: auto;" /></P><P></P><P>If I were to show only the HH numbers, Qlik Sense sorts it perfectly. However, when I input &amp; '00hrs' into the function such that it shows '1100hrs' instead of just '11', the order gets jumbled up.</P><P></P><P>Is there any way for me to write the script?</P><P></P><P><SPAN style="font-size: 13.3333px;">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)</SPAN></P></BODY></HTML> Tue, 20 Oct 2015 03:21:26 GMT https://community.qlik.com/t5/App-Development/Time-Sorting/m-p/926341#M12779 2015-10-20T03:21:26Z Re: Time Sorting https://community.qlik.com/t5/App-Development/Time-Sorting/m-p/926342#M12780 <HTML><HEAD></HEAD><BODY><P>I assume that because your format will change to string .</P><P>Did you try to use Sort Numerically in the Sorting options?</P><P>If that does not help look at:</P><P><A href="https://community.qlik.com/docs/DOC-8106">How to use- Dual()</A></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(18 articles)</A></P></BODY></HTML> Tue, 20 Oct 2015 04:48:08 GMT https://community.qlik.com/t5/App-Development/Time-Sorting/m-p/926342#M12780 robert_mika 2015-10-20T04:48:08Z