topic Re: Sorting Issue in QlikView https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/1346494#M619662 <HTML><HEAD></HEAD><BODY><P>What is your sort expression?</P></BODY></HTML> Wed, 05 Apr 2017 15:18:43 GMT sunny_talwar 2017-04-05T15:18:43Z Sorting Issue https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/1346493#M619661 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>We were trying to create a chart that displays hours from today 4AM(Day) to next day 9AM(Day+1). We were taking a inline table to load this</P><P><SPAN style="font-size: 8pt;">Time_Zone:<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /> Time, date_gateCount<BR /> 05:00, Day<BR /> 06:00, Day<BR /> 07:00, Day<BR /> 08:00, Day<BR /> 09:00, Day<BR /> 10:00, Day<BR /> 11:00, Day<BR /> 12:00, Day<BR /> 13:00, Day<BR /> ...<BR /> 07:00, Day+1<BR /> 08:00, Day+1<BR /> 09:00, Day+1<BR />&nbsp; ]</SPAN><SPAN style="font-size: 8pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">However we are using the match() function but the chart is not coming properly accordingly time 4AM to 9AM.I think there is a sorting issue between these two fields date_gateCount and Time.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159097_pastedImage_356.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Kindly suggest.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt;">Aneesha</SPAN></P></BODY></HTML> Wed, 05 Apr 2017 11:53:45 GMT https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/1346493#M619661 2017-04-05T11:53:45Z Re: Sorting Issue https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/1346494#M619662 <HTML><HEAD></HEAD><BODY><P>What is your sort expression?</P></BODY></HTML> Wed, 05 Apr 2017 15:18:43 GMT https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/1346494#M619662 sunny_talwar 2017-04-05T15:18:43Z Re: Sorting Issue https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/1346495#M619663 <HTML><HEAD></HEAD><BODY><P>please post a sample application to demonstrate.</P></BODY></HTML> Wed, 05 Apr 2017 22:45:38 GMT https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/1346495#M619663 MarcoWedel 2017-04-05T22:45:38Z Re: Sorting Issue https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/1346496#M619664 <HTML><HEAD></HEAD><BODY><P><IMG alt="sort expression.PNG" class="jive-image image-1" src="/legacyfs/online/159382_sort expression.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 07 Apr 2017 07:18:27 GMT https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/1346496#M619664 2017-04-07T07:18:27Z