topic Top 10 values in App Development https://community.qlik.com/t5/App-Development/Top-10-values/m-p/1650090#M48494 <P>Hi,<BR />While limiting the dimension"Code" to the top 10 and sorting by Quantity desc, I get the exact 10 records in the Qlik sense app.<BR />But when I filter the top 10 records in a pivot table, I get extra records because the bottom records have the same values.<BR /><BR />How can I get the same thing in Qlik as well?<BR />Below is my pivot table-</P><TABLE><TBODY><TR><TD>Code</TD><TD>Quantity</TD></TR><TR><TD>4H</TD><TD>5</TD></TR><TR><TD>1I</TD><TD>5</TD></TR><TR><TD>1P</TD><TD>4</TD></TR><TR><TD>4W</TD><TD>3</TD></TR><TR><TD>4P</TD><TD>3</TD></TR><TR><TD>5O</TD><TD>2</TD></TR><TR><TD>1Y</TD><TD>2</TD></TR><TR><TD>1L</TD><TD>1</TD></TR><TR><TD>1C</TD><TD>1</TD></TR><TR><TD>1K</TD><TD>1</TD></TR><TR><TD>1J</TD><TD>1</TD></TR><TR><TD>4G</TD><TD>1</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 19:36:30 GMT eri 2024-11-16T19:36:30Z Top 10 values https://community.qlik.com/t5/App-Development/Top-10-values/m-p/1650090#M48494 <P>Hi,<BR />While limiting the dimension"Code" to the top 10 and sorting by Quantity desc, I get the exact 10 records in the Qlik sense app.<BR />But when I filter the top 10 records in a pivot table, I get extra records because the bottom records have the same values.<BR /><BR />How can I get the same thing in Qlik as well?<BR />Below is my pivot table-</P><TABLE><TBODY><TR><TD>Code</TD><TD>Quantity</TD></TR><TR><TD>4H</TD><TD>5</TD></TR><TR><TD>1I</TD><TD>5</TD></TR><TR><TD>1P</TD><TD>4</TD></TR><TR><TD>4W</TD><TD>3</TD></TR><TR><TD>4P</TD><TD>3</TD></TR><TR><TD>5O</TD><TD>2</TD></TR><TR><TD>1Y</TD><TD>2</TD></TR><TR><TD>1L</TD><TD>1</TD></TR><TR><TD>1C</TD><TD>1</TD></TR><TR><TD>1K</TD><TD>1</TD></TR><TR><TD>1J</TD><TD>1</TD></TR><TR><TD>4G</TD><TD>1</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 19:36:30 GMT https://community.qlik.com/t5/App-Development/Top-10-values/m-p/1650090#M48494 eri 2024-11-16T19:36:30Z Re: Top 10 values https://community.qlik.com/t5/App-Development/Top-10-values/m-p/1650103#M48495 <P>Perhaps use <STRONG>Aggr(Code, Code) </STRONG>as condition</P> Fri, 22 Nov 2019 13:04:06 GMT https://community.qlik.com/t5/App-Development/Top-10-values/m-p/1650103#M48495 Anil_Babu_Samineni 2019-11-22T13:04:06Z Re: Top 10 values https://community.qlik.com/t5/App-Development/Top-10-values/m-p/1650129#M48499 <P>Can you tell me where should i use this condition?</P> Fri, 22 Nov 2019 13:29:44 GMT https://community.qlik.com/t5/App-Development/Top-10-values/m-p/1650129#M48499 eri 2019-11-22T13:29:44Z