topic Re: Sortorder (weekday+date) in pivottable in QlikView https://community.qlik.com/t5/QlikView/Sortorder-weekday-date-in-pivottable/m-p/1301576#M405578 <HTML><HEAD></HEAD><BODY><P>May be this sort order in the cycle group itself</P><P><STRONG>=RangeSum((Dim * 1E10), Date#(SubField(WeekDayName, ' ', -1), 'D-M-YYYY'))</STRONG></P></BODY></HTML> Mon, 08 May 2017 12:05:11 GMT sunny_talwar 2017-05-08T12:05:11Z Sortorder (weekday+date) in pivottable https://community.qlik.com/t5/QlikView/Sortorder-weekday-date-in-pivottable/m-p/1301575#M405577 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>In attached qvw is a pivottable with a dimension 'WeekDay+Date' horizontal. But somehow i cannot get the order right.</P><P></P><P>Can anybody help me out on this one?</P><P></P><P>Thank you in advance!</P></BODY></HTML> Mon, 08 May 2017 11:50:31 GMT https://community.qlik.com/t5/QlikView/Sortorder-weekday-date-in-pivottable/m-p/1301575#M405577 bartvanwetten 2017-05-08T11:50:31Z Re: Sortorder (weekday+date) in pivottable https://community.qlik.com/t5/QlikView/Sortorder-weekday-date-in-pivottable/m-p/1301576#M405578 <HTML><HEAD></HEAD><BODY><P>May be this sort order in the cycle group itself</P><P><STRONG>=RangeSum((Dim * 1E10), Date#(SubField(WeekDayName, ' ', -1), 'D-M-YYYY'))</STRONG></P></BODY></HTML> Mon, 08 May 2017 12:05:11 GMT https://community.qlik.com/t5/QlikView/Sortorder-weekday-date-in-pivottable/m-p/1301576#M405578 sunny_talwar 2017-05-08T12:05:11Z Re: Sortorder (weekday+date) in pivottable https://community.qlik.com/t5/QlikView/Sortorder-weekday-date-in-pivottable/m-p/1301577#M405579 <HTML><HEAD></HEAD><BODY><P>And again works fine!</P></BODY></HTML> Mon, 08 May 2017 12:22:01 GMT https://community.qlik.com/t5/QlikView/Sortorder-weekday-date-in-pivottable/m-p/1301577#M405579 bartvanwetten 2017-05-08T12:22:01Z