topic Re: Problem sorting dimension drilldown in QlikView https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299377#M405177 <HTML><HEAD></HEAD><BODY><P>Would you please verify, that MonthYear is a numeric field?</P><P></P><P>Peter</P></BODY></HTML> Mon, 08 May 2017 08:34:04 GMT prieper 2017-05-08T08:34:04Z Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299371#M405171 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>i have a same problem for the sorting dimension drilldown.</P><P>field :</P><P>1. MonthYear</P><P>2. ID_BANK (Primary key)</P><P></P><P>why field ID_BANK first <SPAN style="font-size: 13.3333px;">one</SPAN> <SPAN style="font-size: 13.3333px;">sort&nbsp; a</SPAN>lways position ?</P><P></P><P>i need first one sort monthyear position</P><P></P><P>thank for help</P></BODY></HTML> Mon, 08 May 2017 06:27:32 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299371#M405171 mfikrirahmat 2017-05-08T06:27:32Z Re: Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299372#M405172 <HTML><HEAD></HEAD><BODY><P>Set the sort order for the drill down group elements using the "Sort Orders..." button the the group edit screen:</P></BODY></HTML> Mon, 08 May 2017 06:44:34 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299372#M405172 jonathandienst 2017-05-08T06:44:34Z Re: Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299373#M405173 <HTML><HEAD></HEAD><BODY><P>i'm to try this (check uncheck) , but not working sorting position </P><P></P><P></P><P><IMG alt="DRILLDOWN 2.png" class="jive-image image-1" src="/legacyfs/online/162445_DRILLDOWN 2.png" style="height: 302px; width: 620px;" /></P></BODY></HTML> Mon, 08 May 2017 06:52:01 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299373#M405173 mfikrirahmat 2017-05-08T06:52:01Z Re: Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299374#M405174 <HTML><HEAD></HEAD><BODY><P>Un-Check the <STRONG>State Ascending</STRONG></P></BODY></HTML> Mon, 08 May 2017 06:55:43 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299374#M405174 Anil_Babu_Samineni 2017-05-08T06:55:43Z Re: Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299375#M405175 <HTML><HEAD></HEAD><BODY><P>i'm trying this, but not work , i need first one display dimension monthyear , </P></BODY></HTML> Mon, 08 May 2017 07:14:51 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299375#M405175 mfikrirahmat 2017-05-08T07:14:51Z Re: Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299376#M405176 <HTML><HEAD></HEAD><BODY><P>Can you upload an example?</P><P></P><P>Siva</P></BODY></HTML> Mon, 08 May 2017 08:25:53 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299376#M405176 Siva_Sankar 2017-05-08T08:25:53Z Re: Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299377#M405177 <HTML><HEAD></HEAD><BODY><P>Would you please verify, that MonthYear is a numeric field?</P><P></P><P>Peter</P></BODY></HTML> Mon, 08 May 2017 08:34:04 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299377#M405177 prieper 2017-05-08T08:34:04Z Re: Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299378#M405178 <HTML><HEAD></HEAD><BODY><P>value monthyear = May 2016</P></BODY></HTML> Mon, 08 May 2017 08:47:59 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299378#M405178 mfikrirahmat 2017-05-08T08:47:59Z Re: Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299379#M405179 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">the file is very bid , i con not upload </SPAN></P><P><SPAN style="font-size: 10pt;">this screenshoot</SPAN></P><P><SPAN style="font-size: 10pt;"><IMG alt="Drildown.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162458_Drildown.png" style="height: 349px; width: 620px;" /></SPAN></P><P><SPAN style="font-size: 10pt;">i want the first to appear dimension monthyear , not id_bank<BR /></SPAN></P><P></P><P><SPAN style="color: #212121; font-size: 29px; font-family: arial, sans-serif;"><BR /></SPAN></P></BODY></HTML> Mon, 08 May 2017 08:58:23 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299379#M405179 mfikrirahmat 2017-05-08T08:58:23Z Re: Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299380#M405180 <HTML><HEAD></HEAD><BODY><P>Ok.</P><P>Select Edit group from the dimension,</P><P>then select and highlight the&nbsp; group (in your case DW_GWMLFR)</P><P>then Edit again, Group settings dialog box will open</P><P>in Group settings dialog box, you will see the fields MonthYear and IDBank,</P><P>Select MonthYear and hit promote button. Click ok</P><P></P><P>Siva</P></BODY></HTML> Mon, 08 May 2017 09:27:15 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299380#M405180 Siva_Sankar 2017-05-08T09:27:15Z Re: Problem sorting dimension drilldown https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299381#M405181 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162464_Capture.JPG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Mon, 08 May 2017 09:27:48 GMT https://community.qlik.com/t5/QlikView/Problem-sorting-dimension-drilldown/m-p/1299381#M405181 Siva_Sankar 2017-05-08T09:27:48Z