https://community.qlik.com/t5/App-Development/Pivot-Table-Sorting-for-multiple-dimension/m-p/2126462#M91672 <P>Hi Qlik family,</P> <P>I have three dimension field (Company, H1 &amp; H2) .I am trying to sort dimension in pivot table as per my dimension mapping num.&nbsp;</P> <P>When I go for the company and H1 it is showing correct sorting order but for h2 it is not correct i have tried everything but its not working.</P> <P>for e.g</P> <P>Rank(min(H2_NUM))</P> <P>Dual(H2_DESC, H2_NUM)</P> <P>Note: sorting is based on the mapping number not on measure.</P> Fri, 15 Nov 2024 21:21:02 GMT md_talib 2024-11-15T21:21:02Z https://community.qlik.com/t5/App-Development/Pivot-Table-Sorting-for-multiple-dimension/m-p/2126462#M91672 <P>Hi Qlik family,</P> <P>I have three dimension field (Company, H1 &amp; H2) .I am trying to sort dimension in pivot table as per my dimension mapping num.&nbsp;</P> <P>When I go for the company and H1 it is showing correct sorting order but for h2 it is not correct i have tried everything but its not working.</P> <P>for e.g</P> <P>Rank(min(H2_NUM))</P> <P>Dual(H2_DESC, H2_NUM)</P> <P>Note: sorting is based on the mapping number not on measure.</P> Fri, 15 Nov 2024 21:21:02 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-Sorting-for-multiple-dimension/m-p/2126462#M91672 md_talib 2024-11-15T21:21:02Z