topic Re: Top 10 In Straight Table in QlikView https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988777#M467693 <HTML><HEAD></HEAD><BODY><P>Ahhhh I had show other values ticked, hence it didn't work previously.&nbsp; Thanks all!</P></BODY></HTML> Thu, 29 Oct 2015 11:06:50 GMT dmac1971 2015-10-29T11:06:50Z Top 10 In Straight Table https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988774#M467690 <HTML><HEAD></HEAD><BODY><P>So I have a straight table with quite a few dimensions and one expression :</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;"> ({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">STATUS</SPAN><SPAN style="font-size: 8pt;"> = {'OPEN'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">TYPE</SPAN><SPAN style="font-size: 8pt;"> = {'TECH},</SPAN><SPAN style="color: #800000; font-size: 8pt;">LOCATION</SPAN><SPAN style="font-size: 8pt;"> = {'UK'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">AGE</SPAN><SPAN style="font-size: 8pt;">)</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">How can I limit the table to the top 10 oldest tickets based on this expression? TIA!</SPAN></P><P></P></BODY></HTML> Thu, 29 Oct 2015 10:57:19 GMT https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988774#M467690 dmac1971 2015-10-29T10:57:19Z Re: Top 10 In Straight Table https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988775#M467691 <HTML><HEAD></HEAD><BODY><P>You sort per value and in the properties the chart, on sheet Dimension Limits, you need to check restrict which values are displayed using the first expression.</P><P></P><P></P><P>Regards</P><P>Marcos Freire</P></BODY></HTML> Thu, 29 Oct 2015 11:03:03 GMT https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988775#M467691 2015-10-29T11:03:03Z Re: Top 10 In Straight Table https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988776#M467692 <HTML><HEAD></HEAD><BODY><P>Within the object-properties to this table is a tab restrictions - here you could specify this quite easily.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 29 Oct 2015 11:03:55 GMT https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988776#M467692 marcus_sommer 2015-10-29T11:03:55Z Re: Top 10 In Straight Table https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988777#M467693 <HTML><HEAD></HEAD><BODY><P>Ahhhh I had show other values ticked, hence it didn't work previously.&nbsp; Thanks all!</P></BODY></HTML> Thu, 29 Oct 2015 11:06:50 GMT https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988777#M467693 dmac1971 2015-10-29T11:06:50Z Re: Top 10 In Straight Table https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988778#M467694 <HTML><HEAD></HEAD><BODY><P>Go to chart properties-&gt; Dimension limit -&gt; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">check restrict which values are displayed using the first expression. -&gt; Select largest and Values =10</SPAN></P></BODY></HTML> Thu, 29 Oct 2015 11:09:26 GMT https://community.qlik.com/t5/QlikView/Top-10-In-Straight-Table/m-p/988778#M467694 Kushal_Chawda 2015-10-29T11:09:26Z