topic Re: [ASK] Sort by Fiscal Week in QlikView https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640135#M234621 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>DId you try sorting using an expression?</P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/59241_pastedImage_1.png" style="width: 620px; height: 546px;" /></P><P></P><P>Cheers,</P><P>Antoine</P></BODY></HTML> Tue, 20 May 2014 21:08:26 GMT Anonymous 2014-05-20T21:08:26Z [ASK] Sort by Fiscal Week https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640134#M234620 <HTML><HEAD></HEAD><BODY><P>Hallo qlikview user..</P><P></P><P>i have an issue with sorting.</P><P></P><P>So in my chart i use WeekOfYear as dimension, and have an expression..</P><P>My sort is with expression (checked) : FiscalWeekOrder</P><P></P><P>But my sort result is still not as i expected.</P><P></P><P>How to solve this?</P><P></P><P>many thx</P></BODY></HTML> Tue, 20 May 2014 14:29:29 GMT https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640134#M234620 2014-05-20T14:29:29Z Re: [ASK] Sort by Fiscal Week https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640135#M234621 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>DId you try sorting using an expression?</P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/59241_pastedImage_1.png" style="width: 620px; height: 546px;" /></P><P></P><P>Cheers,</P><P>Antoine</P></BODY></HTML> Tue, 20 May 2014 21:08:26 GMT https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640135#M234621 Anonymous 2014-05-20T21:08:26Z Re: [ASK] Sort by Fiscal Week https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640136#M234622 <HTML><HEAD></HEAD><BODY><P>yes i did but still not as i expected..</P></BODY></HTML> Wed, 21 May 2014 04:27:57 GMT https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640136#M234622 2014-05-21T04:27:57Z Re: [ASK] Sort by Fiscal Week https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640137#M234623 <HTML><HEAD></HEAD><BODY><P>can you attach your qvw?</P></BODY></HTML> Wed, 21 May 2014 04:33:51 GMT https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640137#M234623 2014-05-21T04:33:51Z Re: [ASK] Sort by Fiscal Week https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640138#M234624 <HTML><HEAD></HEAD><BODY><P>This could be because - may be, your fiscal year field is created as text and there is no dual() used to give it a proper numerical value. Try to share your sample qvw here.</P></BODY></HTML> Wed, 21 May 2014 04:51:24 GMT https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640138#M234624 tresB 2014-05-21T04:51:24Z Re: [ASK] Sort by Fiscal Week https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640139#M234625 <HTML><HEAD></HEAD><BODY><P>Please, post a screenshot of what is it doing now, and explain what is it that you expect.</P></BODY></HTML> Wed, 21 May 2014 06:54:59 GMT https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640139#M234625 Anonymous 2014-05-21T06:54:59Z Re: Re: [ASK] Sort by Fiscal Week https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640140#M234626 <HTML><HEAD></HEAD><BODY><P>hello everyone..</P><P></P><P>many thx for your reply,</P><P></P><P>but i think it will more clear if we move to <A href="https://community.qlik.com/message/533395">[ASK] sort Week Of Year by Fiscal Week</A></P><P></P><P>once again, many thx...</P></BODY></HTML> Thu, 22 May 2014 06:50:52 GMT https://community.qlik.com/t5/QlikView/ASK-Sort-by-Fiscal-Week/m-p/640140#M234626 2014-05-22T06:50:52Z