topic Ranking Dimension by multiple measures in QlikView https://community.qlik.com/t5/QlikView/Ranking-Dimension-by-multiple-measures/m-p/1952992#M1219813 <P>Hi,&nbsp; I have an unusual chart to build and I'm struggling to build it as the user is asking.&nbsp;&nbsp;</P> <P>To simplify I have 1 dimension and 4 measures</P> <P>&nbsp;</P> <TABLE style="border-collapse: collapse; width: 240pt;" border="0" width="320" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="64" height="20" style="height: 15.0pt; width: 48pt;">&nbsp;</TD> <TD width="64" style="width: 48pt;">Measure1</TD> <TD width="64" style="width: 48pt;">Measure2</TD> <TD width="64" style="width: 48pt;">Measure3</TD> <TD width="64" style="width: 48pt;">Measure4</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim1</TD> <TD align="right">1</TD> <TD align="right">2</TD> <TD align="right">3</TD> <TD align="right">4</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim2</TD> <TD align="right">2</TD> <TD align="right">3</TD> <TD align="right">4</TD> <TD align="right">5</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim3</TD> <TD align="right">3</TD> <TD align="right">4</TD> <TD align="right">5</TD> <TD align="right">6</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim4</TD> <TD align="right">4</TD> <TD align="right">5</TD> <TD align="right">6</TD> <TD align="right">1</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim5</TD> <TD align="right">5</TD> <TD align="right">6</TD> <TD align="right">1</TD> <TD align="right">2</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim6</TD> <TD align="right">6</TD> <TD align="right">1</TD> <TD align="right">2</TD> <TD align="right">3</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>They want it displayed with a rank on the left and the dimensions sorted by the value of each measure but displaying the dimension name.</P> <P>&nbsp;</P> <TABLE style="border-collapse: collapse; width: 240pt;" border="0" width="320" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="64" height="20" align="right" style="height: 15.0pt; width: 48pt;">1</TD> <TD width="64" style="width: 48pt;">Dim1</TD> <TD width="64" style="width: 48pt;">Dim6</TD> <TD width="64" style="width: 48pt;">Dim5</TD> <TD width="64" style="width: 48pt;">Dim4</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" style="height: 15.0pt;">2</TD> <TD>Dim2</TD> <TD>Dim1</TD> <TD>Dim6</TD> <TD>Dim5</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" style="height: 15.0pt;">3</TD> <TD>Dim3</TD> <TD>Dim2</TD> <TD>Dim1</TD> <TD>Dim6</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" style="height: 15.0pt;">4</TD> <TD>Dim4</TD> <TD>Dim3</TD> <TD>Dim2</TD> <TD>Dim1</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" style="height: 15.0pt;">5</TD> <TD>Dim5</TD> <TD>Dim4</TD> <TD>Dim3</TD> <TD>Dim2</TD> </TR> </TBODY> </TABLE> Thu, 07 Jul 2022 16:09:41 GMT msanchez 2022-07-07T16:09:41Z Ranking Dimension by multiple measures https://community.qlik.com/t5/QlikView/Ranking-Dimension-by-multiple-measures/m-p/1952992#M1219813 <P>Hi,&nbsp; I have an unusual chart to build and I'm struggling to build it as the user is asking.&nbsp;&nbsp;</P> <P>To simplify I have 1 dimension and 4 measures</P> <P>&nbsp;</P> <TABLE style="border-collapse: collapse; width: 240pt;" border="0" width="320" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="64" height="20" style="height: 15.0pt; width: 48pt;">&nbsp;</TD> <TD width="64" style="width: 48pt;">Measure1</TD> <TD width="64" style="width: 48pt;">Measure2</TD> <TD width="64" style="width: 48pt;">Measure3</TD> <TD width="64" style="width: 48pt;">Measure4</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim1</TD> <TD align="right">1</TD> <TD align="right">2</TD> <TD align="right">3</TD> <TD align="right">4</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim2</TD> <TD align="right">2</TD> <TD align="right">3</TD> <TD align="right">4</TD> <TD align="right">5</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim3</TD> <TD align="right">3</TD> <TD align="right">4</TD> <TD align="right">5</TD> <TD align="right">6</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim4</TD> <TD align="right">4</TD> <TD align="right">5</TD> <TD align="right">6</TD> <TD align="right">1</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim5</TD> <TD align="right">5</TD> <TD align="right">6</TD> <TD align="right">1</TD> <TD align="right">2</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">Dim6</TD> <TD align="right">6</TD> <TD align="right">1</TD> <TD align="right">2</TD> <TD align="right">3</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>They want it displayed with a rank on the left and the dimensions sorted by the value of each measure but displaying the dimension name.</P> <P>&nbsp;</P> <TABLE style="border-collapse: collapse; width: 240pt;" border="0" width="320" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="64" height="20" align="right" style="height: 15.0pt; width: 48pt;">1</TD> <TD width="64" style="width: 48pt;">Dim1</TD> <TD width="64" style="width: 48pt;">Dim6</TD> <TD width="64" style="width: 48pt;">Dim5</TD> <TD width="64" style="width: 48pt;">Dim4</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" style="height: 15.0pt;">2</TD> <TD>Dim2</TD> <TD>Dim1</TD> <TD>Dim6</TD> <TD>Dim5</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" style="height: 15.0pt;">3</TD> <TD>Dim3</TD> <TD>Dim2</TD> <TD>Dim1</TD> <TD>Dim6</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" style="height: 15.0pt;">4</TD> <TD>Dim4</TD> <TD>Dim3</TD> <TD>Dim2</TD> <TD>Dim1</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" style="height: 15.0pt;">5</TD> <TD>Dim5</TD> <TD>Dim4</TD> <TD>Dim3</TD> <TD>Dim2</TD> </TR> </TBODY> </TABLE> Thu, 07 Jul 2022 16:09:41 GMT https://community.qlik.com/t5/QlikView/Ranking-Dimension-by-multiple-measures/m-p/1952992#M1219813 msanchez 2022-07-07T16:09:41Z