topic How To Filter Top 10 Dimension Members in QlikView https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276576#M103156 <HTML><HEAD></HEAD><BODY><P>Hello Sven,</P><P>You solution seems to work as it filters top 10 Partner.&nbsp; However, I'm getting an additional bucket "-" that seems to group all else.&nbsp; Is there a way to filter out this bucket?</P><P></P><P>Any help on this is appreciated!</P></BODY></HTML> Wed, 21 Sep 2011 21:05:06 GMT 2011-09-21T21:05:06Z How To Filter Top 10 Dimension Members https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276573#M103153 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I currently have a chart that I am filtering top 10 by presentation property "Max Visible Number"=10</P><P>I want to remove this filter, and apply it in the Dimension coding.</P><P></P><P>How do I filter top 10 Partner Dimension based on the following expressions in decending order</P><P>Sum({&lt;LOB={HOTEL}&gt;}Booking)</P><P></P><P>Your help is appreciated.</P></BODY></HTML> Wed, 21 Sep 2011 01:41:30 GMT https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276573#M103153 2011-09-21T01:41:30Z Re: How To Filter Top 10 Dimension Members https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276574#M103154 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>I have one idea but don't know this one help you or not.</P><P></P><P>1. Create one variable &lt;vMaxShow&gt;<BR />2. Create Slider/Calendar Object (For dynamic show max)<BR /> - Variable(s) : vMaxShow<BR /> - Min Value : 1<BR /> - Max Value : 100<BR /> - Static Step : 1<BR />3. Right Click on Chart ==&gt; Presentation<BR /> - Max Visible Number : Choose variable &lt;vMaxShow&gt; </P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 21 Sep 2011 09:14:36 GMT https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276574#M103154 Sokkorn 2011-09-21T09:14:36Z Re: How To Filter Top 10 Dimension Members https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276575#M103155 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you can do something like</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>aggr(only({&lt;Partner={"=rank(Sum({&lt;LOB={HOTEL}&gt;}Booking),4)&lt;11"}&gt;}Partner),Partner)</P></PRE><P></P><P>but your solution is preferable.</P><P></P><P>Regards</P><P>Sven</P></BODY></HTML> Wed, 21 Sep 2011 09:15:27 GMT https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276575#M103155 s_uhlig 2011-09-21T09:15:27Z How To Filter Top 10 Dimension Members https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276576#M103156 <HTML><HEAD></HEAD><BODY><P>Hello Sven,</P><P>You solution seems to work as it filters top 10 Partner.&nbsp; However, I'm getting an additional bucket "-" that seems to group all else.&nbsp; Is there a way to filter out this bucket?</P><P></P><P>Any help on this is appreciated!</P></BODY></HTML> Wed, 21 Sep 2011 21:05:06 GMT https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276576#M103156 2011-09-21T21:05:06Z How To Filter Top 10 Dimension Members https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276577#M103157 <HTML><HEAD></HEAD><BODY><P>Sure, there is a checkbox "Suppress When Value Is Null" below your dimension.</P></BODY></HTML> Wed, 21 Sep 2011 23:29:47 GMT https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276577#M103157 s_uhlig 2011-09-21T23:29:47Z How To Filter Top 10 Dimension Members https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276578#M103158 <HTML><HEAD></HEAD><BODY><P>It works like a charm.</P><P>However, since the dimension is the long calculated expression.&nbsp; It does not show the actual Partner for each bar (dimension members).&nbsp; It just shows the entire dimension expression.&nbsp; Do you know how it can render the dimension labels correctly?</P><P></P><P>Your help is appreciated!</P></BODY></HTML> Wed, 21 Sep 2011 23:59:39 GMT https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276578#M103158 2011-09-21T23:59:39Z Re: How To Filter Top 10 Dimension Members https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276579#M103159 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I'm sure you will figure it out yourself. The direction is pretty much the same as one before.</P><P></P><P>Regards</P><P>Sven</P></BODY></HTML> Thu, 22 Sep 2011 08:13:44 GMT https://community.qlik.com/t5/QlikView/How-To-Filter-Top-10-Dimension-Members/m-p/276579#M103159 s_uhlig 2011-09-22T08:13:44Z