topic Re: Help needed to sort a Cyclic chart in QlikView https://community.qlik.com/t5/QlikView/Help-needed-to-sort-a-Cyclic-chart/m-p/1038463#M942699 <HTML><HEAD></HEAD><BODY><P>Try a sort expression like</P><P></P><P>=If(GetCurrentField( "New Group" )='Date', Date, -sum(Value))</P></BODY></HTML> Wed, 20 Jan 2016 16:44:05 GMT swuehl 2016-01-20T16:44:05Z Help needed to sort a Cyclic chart https://community.qlik.com/t5/QlikView/Help-needed-to-sort-a-Cyclic-chart/m-p/1038462#M942698 <HTML><HEAD></HEAD><BODY><P>I am trying to sort out the sorting of a cyclic chart but with no luck. The chart starts with month and then category then product which all works marvelously. My issue is the sorting. I want the Month to obviously be sorted in month order, which I have, but then on the products and categories I want it sorted by value (descending). Any ideas on how to achieve this? Attached is a sample file</P></BODY></HTML> Wed, 20 Jan 2016 12:59:03 GMT https://community.qlik.com/t5/QlikView/Help-needed-to-sort-a-Cyclic-chart/m-p/1038462#M942698 2016-01-20T12:59:03Z Re: Help needed to sort a Cyclic chart https://community.qlik.com/t5/QlikView/Help-needed-to-sort-a-Cyclic-chart/m-p/1038463#M942699 <HTML><HEAD></HEAD><BODY><P>Try a sort expression like</P><P></P><P>=If(GetCurrentField( "New Group" )='Date', Date, -sum(Value))</P></BODY></HTML> Wed, 20 Jan 2016 16:44:05 GMT https://community.qlik.com/t5/QlikView/Help-needed-to-sort-a-Cyclic-chart/m-p/1038463#M942699 swuehl 2016-01-20T16:44:05Z Re: Help needed to sort a Cyclic chart https://community.qlik.com/t5/QlikView/Help-needed-to-sort-a-Cyclic-chart/m-p/1038464#M942700 <HTML><HEAD></HEAD><BODY><P>Check the attached</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112130_Capture.PNG" style="height: 459px; width: 620px;" /></P></BODY></HTML> Wed, 20 Jan 2016 16:44:41 GMT https://community.qlik.com/t5/QlikView/Help-needed-to-sort-a-Cyclic-chart/m-p/1038464#M942700 sunny_talwar 2016-01-20T16:44:41Z Re: Help needed to sort a Cyclic chart https://community.qlik.com/t5/QlikView/Help-needed-to-sort-a-Cyclic-chart/m-p/1038465#M942701 <HTML><HEAD></HEAD><BODY><P>Both scenarios worked beautifully,&nbsp; thanks guys much appreciated</P></BODY></HTML> Thu, 21 Jan 2016 08:04:01 GMT https://community.qlik.com/t5/QlikView/Help-needed-to-sort-a-Cyclic-chart/m-p/1038465#M942701 2016-01-21T08:04:01Z