topic Re: How to do the Sorting ? in QlikView https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103680#M915571 <HTML><HEAD></HEAD><BODY><P>hi bro,</P><P>i also given same answer na <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 19 May 2016 12:07:03 GMT Chanty4u 2016-05-19T12:07:03Z How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103667#M915558 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In my Chart the sorting is not happening correctly .</P><P>Please suggest.</P><P></P><P>My requirement is :</P><P>How to sort the Straight table chart accordingly.</P><P>Like :</P><P>Full Year Chart</P><P>planning Month :</P><P>Jul</P><P>Aug</P><P>Sep</P><P>Oct</P><P>Nov</P><P>Dec</P><P>Jan</P><P>Feb</P><P>Mar</P><P>Apr</P><P>May</P><P>Jun</P><P></P><P></P><P>1st Half Of the Year</P><P>Jul</P><P>Aug</P><P>Sep</P><P>Oct</P><P>Nov</P><P>Dec</P><P></P><P>2nd Half of the year</P><P>Jan</P><P>Feb</P><P>Mar</P><P>Apr</P><P>May</P><P>Jun </P><P></P><P></P><P>Sample qlikvie model attached.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103667#M915558 suvechha_b 2020-11-25T16:16:04Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103668#M915559 <HTML><HEAD></HEAD><BODY><P>Isn't how this is sorted right now in your sample?</P></BODY></HTML> Thu, 19 May 2016 11:34:45 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103668#M915559 sunny_talwar 2016-05-19T11:34:45Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103669#M915560 <HTML><HEAD></HEAD><BODY><P>did u tried here?</P><P><IMG alt="sorting.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125038_sorting.PNG" style="height: 388px; width: 620px;" /></P></BODY></HTML> Thu, 19 May 2016 11:35:34 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103669#M915560 Chanty4u 2016-05-19T11:35:34Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103670#M915561 <HTML><HEAD></HEAD><BODY><P>orelse </P><P>use sort tab--&gt;expression like</P><P></P><P>Match(Field,'jan','feb',..............)</P></BODY></HTML> Thu, 19 May 2016 11:36:30 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103670#M915561 Chanty4u 2016-05-19T11:36:30Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103671#M915562 <HTML><HEAD></HEAD><BODY><P>No Check the Full Year Chart </P><P>Planning Month </P><P>Apr coming after Dec.</P></BODY></HTML> Thu, 19 May 2016 11:40:28 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103671#M915562 suvechha_b 2016-05-19T11:40:28Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103672#M915563 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Try something like below as Expression :</P><P></P><P>Dual(Month,Match(Month,'jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec')) </P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125054_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Thu, 19 May 2016 11:45:25 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103672#M915563 amit_saini 2016-05-19T11:45:25Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103673#M915564 <HTML><HEAD></HEAD><BODY><P>Didn't work</P></BODY></HTML> Thu, 19 May 2016 11:48:10 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103673#M915564 suvechha_b 2016-05-19T11:48:10Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103674#M915565 <HTML><HEAD></HEAD><BODY><P>Didn't work</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125055_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 19 May 2016 11:53:22 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103674#M915565 suvechha_b 2016-05-19T11:53:22Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103675#M915566 <HTML><HEAD></HEAD><BODY><P>Didnt work.<IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125056_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 19 May 2016 11:54:56 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103675#M915566 suvechha_b 2016-05-19T11:54:56Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103676#M915567 <HTML><HEAD></HEAD><BODY><P>Just promote (use Promote button) Planning Month over RO in "Sort" tab and you will have correct result on your Full Year chart. Take a look at attachement.</P></BODY></HTML> Thu, 19 May 2016 11:57:31 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103676#M915567 2016-05-19T11:57:31Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103677#M915568 <HTML><HEAD></HEAD><BODY><P>Match will work</P></BODY></HTML> Thu, 19 May 2016 11:58:59 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103677#M915568 Chanty4u 2016-05-19T11:58:59Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103678#M915569 <HTML><HEAD></HEAD><BODY><P>Check the attached:</P><P></P><P><STRONG>=Match([Planning Month],'Jul','Aug','Sep','Oct','Nov','Dec', 'Jan','Feb','Mar','Apr','May','Jun')</STRONG></P></BODY></HTML> Thu, 19 May 2016 11:59:38 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103678#M915569 sunny_talwar 2016-05-19T11:59:38Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103679#M915570 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try with <STRONG>Load order</STRONG></P><P></P><P>see attached one</P></BODY></HTML> Thu, 19 May 2016 12:04:24 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103679#M915570 2016-05-19T12:04:24Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103680#M915571 <HTML><HEAD></HEAD><BODY><P>hi bro,</P><P>i also given same answer na <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 19 May 2016 12:07:03 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103680#M915571 Chanty4u 2016-05-19T12:07:03Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103681#M915572 <HTML><HEAD></HEAD><BODY><P>Hope, attached is what you want.</P></BODY></HTML> Thu, 19 May 2016 12:13:24 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103681#M915572 2016-05-19T12:13:24Z Re: How to do the Sorting ? https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103682#M915573 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="125061" alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125061_Untitled.png" style="height: 349px; width: 620px;" />Hi</P><P>Try like this</P></BODY></HTML> Thu, 19 May 2016 12:19:12 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-Sorting/m-p/1103682#M915573 qlikview979 2016-05-19T12:19:12Z