topic Re: Custom Sort (Cycle) Dimension in QlikView https://community.qlik.com/t5/QlikView/Custom-Sort-Cycle-Dimension/m-p/951573#M327268 <HTML><HEAD></HEAD><BODY><P>You can determine a sort order by first loading the values in the script in the order you want them in a temporary table. You can then sort by Load Order. Or you can sort by expression: match(only({1}[Dimension 1]), 'B','D','E','A','C')</P></BODY></HTML> Wed, 19 Aug 2015 08:06:26 GMT Gysbert_Wassenaar 2015-08-19T08:06:26Z Custom Sort (Cycle) Dimension https://community.qlik.com/t5/QlikView/Custom-Sort-Cycle-Dimension/m-p/951572#M327267 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an pivot table with a dimension which a want to sort on custom order, </P><P></P><P>Let say's Dimension 1 with Fields </P><P>A</P><P>B</P><P>C</P><P>D</P><P>E</P><P></P><P>But I want to sort by the following order: </P><P>B</P><P>D</P><P>E</P><P>A</P><P>C </P><P></P><P>How do i realize this? With an Inline script and an Expression?</P><P></P><P>Thanks</P><P>Robert</P></BODY></HTML> Wed, 19 Aug 2015 07:59:04 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-Cycle-Dimension/m-p/951572#M327267 Anonymous 2015-08-19T07:59:04Z Re: Custom Sort (Cycle) Dimension https://community.qlik.com/t5/QlikView/Custom-Sort-Cycle-Dimension/m-p/951573#M327268 <HTML><HEAD></HEAD><BODY><P>You can determine a sort order by first loading the values in the script in the order you want them in a temporary table. You can then sort by Load Order. Or you can sort by expression: match(only({1}[Dimension 1]), 'B','D','E','A','C')</P></BODY></HTML> Wed, 19 Aug 2015 08:06:26 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-Cycle-Dimension/m-p/951573#M327268 Gysbert_Wassenaar 2015-08-19T08:06:26Z Re: Custom Sort (Cycle) Dimension https://community.qlik.com/t5/QlikView/Custom-Sort-Cycle-Dimension/m-p/951574#M327269 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert, </P><P></P><P>Option 1 worked fine, thanks. </P><P>But can you explain option 1 a bit further how the solution should work?</P></BODY></HTML> Wed, 19 Aug 2015 09:21:20 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-Cycle-Dimension/m-p/951574#M327269 Anonymous 2015-08-19T09:21:20Z