topic Re: Custom Sort Order in a Pivot in QlikView https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301484#M405560 <HTML><HEAD></HEAD><BODY><P>By using the Pivot Table, It can only sort the first dimension ( not matter depends on what conditions) then the second dimension and so on. </P><P></P><P>Now the question will be how you sort the dimension, you can choose sort by expression and use aggr function to sort by the value you want to.</P><P></P><P>But in your problem, I cannot see it is applicable to use pivot table. You can use straight table for it.</P><P></P><P>Cheers, </P><P></P><P>Scott </P></BODY></HTML> Thu, 27 Jul 2017 15:29:27 GMT scottyleung 2017-07-27T15:29:27Z Custom Sort Order in a Pivot https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301480#M405556 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am having a multi Dimension and Expression Pivot, where the Dimensions looks like this:</P><P></P><P>1. Customer, 2. Validity, 3. Area, 4. Named Account.</P><P></P><P>The order of these 4 dimensions should stick like they are, BUT I want to sort&nbsp; following priorities 1. <STRONG>Customer</STRONG> alphabetically, 2. <STRONG>Named Account</STRONG> alphabetically and THAN!! 3. Area alphabetically and 4. Area alphabetically.</P><P></P><P><SPAN style="text-decoration: underline;">The special thing on this sorting is, that the order of the 4th column is 2nd important and not the 2nd or 3rd one first!</SPAN></P><P></P><P>My table should like this:</P><P></P><P>Customer, Validity, Area, Named Account</P><P></P><P>HRS, Longtime, Europe, <STRONG>Agoda</STRONG></P><P>Ikea, Shortime, Africa, <STRONG>Agoda</STRONG></P><P>Lubo, Shortime, Europe, Belkin</P><P>Friedrich, Midterm, Europe <STRONG>Z-Company</STRONG></P><P>Golo, Midterm, Asia, <STRONG>Z-Company</STRONG></P><P></P><P>Can anybody please help me with this?</P><P></P><P>Kind Regards,</P><P></P><P></P><P>Chris</P></BODY></HTML> Thu, 27 Jul 2017 08:25:20 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301480#M405556 chriys1337 2017-07-27T08:25:20Z Re: Custom Sort Order in a Pivot https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301481#M405557 <HTML><HEAD></HEAD><BODY><P>Please refer the link below.</P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-7220">Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)</A></P></BODY></HTML> Thu, 27 Jul 2017 08:35:28 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301481#M405557 techvarun 2017-07-27T08:35:28Z Re: Custom Sort Order in a Pivot https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301482#M405558 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I did not find the solution for my problem.</P><P></P><P>I want to change to sort order, my 4th column should be second important. But the original sequence of columns should stay the same, regardless of the defined sorting order.</P><P></P><P>Anybody did this before?</P><P></P><P>kind Regards,</P><P></P><P>Chris</P></BODY></HTML> Thu, 27 Jul 2017 09:29:07 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301482#M405558 chriys1337 2017-07-27T09:29:07Z Re: Custom Sort Order in a Pivot https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301483#M405559 <HTML><HEAD></HEAD><BODY><P>Nobody any idea?</P><P></P><P>Or is it unclear what I want?</P><P></P><P>Kind Regards,</P><P></P><P>Chris</P></BODY></HTML> Thu, 27 Jul 2017 13:55:19 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301483#M405559 chriys1337 2017-07-27T13:55:19Z Re: Custom Sort Order in a Pivot https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301484#M405560 <HTML><HEAD></HEAD><BODY><P>By using the Pivot Table, It can only sort the first dimension ( not matter depends on what conditions) then the second dimension and so on. </P><P></P><P>Now the question will be how you sort the dimension, you can choose sort by expression and use aggr function to sort by the value you want to.</P><P></P><P>But in your problem, I cannot see it is applicable to use pivot table. You can use straight table for it.</P><P></P><P>Cheers, </P><P></P><P>Scott </P></BODY></HTML> Thu, 27 Jul 2017 15:29:27 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-Order-in-a-Pivot/m-p/1301484#M405560 scottyleung 2017-07-27T15:29:27Z