topic Re: Sorting on Bar/Line Chart in QlikView https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100338#M751151 <HTML><HEAD></HEAD><BODY><P>please post a sample application that demonstrates the issue.</P></BODY></HTML> Thu, 01 Nov 2018 22:02:42 GMT MarcoWedel 2018-11-01T22:02:42Z Sorting on Bar/Line Chart https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100334#M751147 <HTML><HEAD></HEAD><BODY><P>My bar/line chart is not sorting correctly.&nbsp; I see my issue.&nbsp; The dates are only sorting where the line bar starts.&nbsp; How do I force the whole chart to sort correctly?</P><P></P><P><IMG alt="Capture2.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217330_Capture2.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100334#M751147 kaylaramsey2 2020-11-25T16:16:04Z Re: Sorting on Bar/Line Chart https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100335#M751148 <HTML><HEAD></HEAD><BODY><P>In properties/Sort , you can use sort by expression and use match() :</P><P></P><P>=match(YourField,'201701','201702','201703','201704','201705',.....)</P></BODY></HTML> Thu, 01 Nov 2018 19:41:01 GMT https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100335#M751148 sergio0592 2018-11-01T19:41:01Z Re: Sorting on Bar/Line Chart https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100336#M751149 <HTML><HEAD></HEAD><BODY><P>Hi this will not work.&nbsp; This chart is going to continue growing everytime we add more data.&nbsp; Doing a match would be very manual.</P></BODY></HTML> Thu, 01 Nov 2018 19:59:19 GMT https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100336#M751149 kaylaramsey2 2018-11-01T19:59:19Z Re: Sorting on Bar/Line Chart https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100337#M751150 <HTML><HEAD></HEAD><BODY><P>Maybe with this sorting expression:</P><P></P><P>num(Date#(YourDateField,'YYYY-MMM'))</P><P></P><P>hope this helps</P></BODY></HTML> Thu, 01 Nov 2018 20:09:33 GMT https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100337#M751150 Frank_Hartmann 2018-11-01T20:09:33Z Re: Sorting on Bar/Line Chart https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100338#M751151 <HTML><HEAD></HEAD><BODY><P>please post a sample application that demonstrates the issue.</P></BODY></HTML> Thu, 01 Nov 2018 22:02:42 GMT https://community.qlik.com/t5/QlikView/Sorting-on-Bar-Line-Chart/m-p/100338#M751151 MarcoWedel 2018-11-01T22:02:42Z