topic Problem with sorting in QlikView https://community.qlik.com/t5/QlikView/Problem-with-sorting/m-p/1337869#M828629 <HTML><HEAD></HEAD><BODY><P>Hello Qliks,</P><P></P><P>I look for a solution how to sort my DIM 1(Year-Month). DIMis a calculated Dimension:</P><P>=if(Year=$(vMaxYear),[Year-Month],null())<IMG alt="DIM1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169274_DIM1.png" style="height: 49px; width: 620px;" /></P><P></P><P>The final result should be<SPAN style="font-size: 10pt;">:</SPAN></P><P><SPAN style="font-size: 10pt;">1. Jun-2017</SPAN></P><P><SPAN style="font-size: 10pt;">2. Feb-2017</SPAN></P><P><SPAN style="font-size: 10pt;">3.....</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Regards</SPAN></P><P><SPAN style="font-size: 10pt;">Jacek.</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Problem with sorting https://community.qlik.com/t5/QlikView/Problem-with-sorting/m-p/1337869#M828629 <HTML><HEAD></HEAD><BODY><P>Hello Qliks,</P><P></P><P>I look for a solution how to sort my DIM 1(Year-Month). DIMis a calculated Dimension:</P><P>=if(Year=$(vMaxYear),[Year-Month],null())<IMG alt="DIM1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169274_DIM1.png" style="height: 49px; width: 620px;" /></P><P></P><P>The final result should be<SPAN style="font-size: 10pt;">:</SPAN></P><P><SPAN style="font-size: 10pt;">1. Jun-2017</SPAN></P><P><SPAN style="font-size: 10pt;">2. Feb-2017</SPAN></P><P><SPAN style="font-size: 10pt;">3.....</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Regards</SPAN></P><P><SPAN style="font-size: 10pt;">Jacek.</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-sorting/m-p/1337869#M828629 Anonymous 2020-11-25T16:16:04Z Re: Problem with sorting https://community.qlik.com/t5/QlikView/Problem-with-sorting/m-p/1337870#M828630 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=if(Year=$(vMaxYear),Date#([Year-Month],'YYYY-MMM'),null())</SPAN></P></BODY></HTML> Thu, 06 Jul 2017 07:41:51 GMT https://community.qlik.com/t5/QlikView/Problem-with-sorting/m-p/1337870#M828630 MK_QSL 2017-07-06T07:41:51Z Re: Problem with sorting https://community.qlik.com/t5/QlikView/Problem-with-sorting/m-p/1337871#M828631 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Thank you, it solved my problem.</P><P></P><P>Regards</P><P>Jacek.</P></BODY></HTML> Thu, 06 Jul 2017 07:45:10 GMT https://community.qlik.com/t5/QlikView/Problem-with-sorting/m-p/1337871#M828631 Anonymous 2017-07-06T07:45:10Z