topic Top xxx based on Slider in QlikView

topic Top xxx based on Slider in QlikView https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213282#M67048 <HTML><HEAD></HEAD><BODY><P>Yes I do have a variable attached to the slider. How would the variable work? For example the user selects 200 from the slider, what would the expression have to look like?</P><P>thanks</P><P>thom</P><P></P></BODY></HTML> Fri, 03 Dec 2010 17:09:38 GMT tmumaw 2010-12-03T17:09:38Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213280#M67046 <HTML><HEAD></HEAD><BODY><P>I have created a slider with values 1 - 500. Then I have a customer list by customer/address, sales $. My user wants to be able to see the number he selected from the slider as a count be side each customer. Something like this. The row count has to be based on the slider. Thanks</P><P></P><P>1 customer 1 address sales $</P><P>2 customer2 address sales $</P></BODY></HTML> Fri, 03 Dec 2010 16:36:19 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213280#M67046 tmumaw 2010-12-03T16:36:19Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213281#M67047 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />Presuming you have a variable attached to the slider in the 1st place; can you not simply add the variable as an expression in the Customer table?<BR />I've just done something similar to a slider in an app I'm working on and it seems to have done the trick; always assuming, of course, that I have interpreted your request correctly!</P><P>Regards,<BR />Jon</P></BODY></HTML> Fri, 03 Dec 2010 16:58:58 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213281#M67047 2010-12-03T16:58:58Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213282#M67048 <HTML><HEAD></HEAD><BODY><P>Yes I do have a variable attached to the slider. How would the variable work? For example the user selects 200 from the slider, what would the expression have to look like?</P><P>thanks</P><P>thom</P><P></P></BODY></HTML> Fri, 03 Dec 2010 17:09:38 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213282#M67048 tmumaw 2010-12-03T17:09:38Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213283#M67049 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />As stated earlier, this is my interpretation of your request!!<BR />Anyway, in my example below the expression = the variable ie my variable is 'vBrowser_Rate':<BR /><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6281.forum2.PNG"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/6281.forum2.PNG" /></A><BR />Apologies in advance if I've misinterpreted your request,<BR />Have a good weekend!</P><P>Jon</P></BODY></HTML> Fri, 03 Dec 2010 17:24:58 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213283#M67049 2010-12-03T17:24:58Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213284#M67050 <HTML><HEAD></HEAD><BODY><P>You are displaying the value of your slider, what I want to do is display a row count based on the number on my slider. Say I selected 100 on my slider. I want to see the top 100 customers, and I want customer 1, 2 ,3, etc all the way to 100.</P><P>Thom</P></BODY></HTML> Fri, 03 Dec 2010 18:49:55 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213284#M67050 tmumaw 2010-12-03T18:49:55Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213285#M67051 <HTML><HEAD></HEAD><BODY><P>Hello Thom,</P><P>1.- Create a variable called vHowMany,</P><P>2.- Create e slider object using this variable, and set its minimum value to 1 and the maximum to</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=Count(DISTINCT DID)</PRE></BLOCKQUOTE><BR /><BR /> <P>DID Is my company code here.</P><P>3.- Use the following as dimension in the chart:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=If(aggr(rank(aggr(sum(SalesAmount), DID), 4, 2), DID) <= $(vHowMany), DID, 'Others')</PRE></BLOCKQUOTE><BR /><BR /> <P>The "Others" in the else statement may help or may not, you can remove it and check "Suppress when values is Null" for this new calculated dimension. I have some examples there if you'd like to see (just this calculated dimension).</P><P>I'm using in the example</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum(SalesAmount)</PRE></BLOCKQUOTE><BR /><BR /> <P>Just to check that the above is correct.</P><P>Hope this helps.</P></BODY></HTML> Fri, 03 Dec 2010 19:15:59 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213285#M67051 Miguel_Angel_Baeyens 2010-12-03T19:15:59Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213286#M67052 <HTML><HEAD></HEAD><BODY><P>Hi Miguel,</P><P>All I see in the calculated column is "Other", what I want to see is how they rank 1,2,3 etc.</P><P>Thanks<BR />Thom</P></BODY></HTML> Fri, 03 Dec 2010 20:58:00 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213286#M67052 tmumaw 2010-12-03T20:58:00Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213287#M67053 <HTML><HEAD></HEAD><BODY><P>Hi Miguel</P><P>Thanks for this smart example. It works perfect. I will use right now.</P><P>JJ</P></BODY></HTML> Fri, 03 Dec 2010 21:06:05 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213287#M67053 2010-12-03T21:06:05Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213288#M67054 <HTML><HEAD></HEAD><BODY><P>Hi Thom,</P><P>It's working fine for me. Anyway, check the attached example.</P><P>Hope that helps.</P></BODY></HTML> Fri, 03 Dec 2010 21:07:16 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213288#M67054 Miguel_Angel_Baeyens 2010-12-03T21:07:16Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213289#M67055 <HTML><HEAD></HEAD><BODY><P>Many thanks Jean-Jacques. Use the file posted above if that helps you.</P><P>Regards.</P></BODY></HTML> Fri, 03 Dec 2010 21:08:45 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213289#M67055 Miguel_Angel_Baeyens 2010-12-03T21:08:45Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213290#M67056 <HTML><HEAD></HEAD><BODY><P>Will this work with multiple dimensions? I have 5 dims (Customer Name, Address, City, State and Zip). Here is my dim logic</P><P>=If(aggr(rank(aggr(sum([Inv Gross]), [Customer - Code & Name]), 4, 2), [Customer - Code & Name]) <= $(vHowMany), [Customer - Code & Name], 'Others')</P><P></P><P>expression :</P><P>Rank(aggr(sum([Inv Gross]), [Customer - Code & Name]), 4, 2)</P><P></P><P>Thanks Thom</P><P></P></BODY></HTML> Fri, 03 Dec 2010 21:37:16 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213290#M67056 tmumaw 2010-12-03T21:37:16Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213291#M67057 <HTML><HEAD></HEAD><BODY><P>Miguel,</P><P>It works fine on just one dimension.</P><P>Thanks<BR />Thom</P></BODY></HTML> Fri, 03 Dec 2010 21:41:41 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213291#M67057 tmumaw 2010-12-03T21:41:41Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213292#M67058 <HTML><HEAD></HEAD><BODY><P>Hi Miguel</P><P>I am a Personal Edition user, so opening your demo is a problem - see error message below. <A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0535.QVW-Pers-Ed-Error.JPG"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/0535.QVW-Pers-Ed-Error.JPG" /></A></P><P>Is there any way around this?</P><P>Joe</P></BODY></HTML> Fri, 10 Dec 2010 11:13:09 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213292#M67058 mazacini 2010-12-10T11:13:09Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213293#M67059 <HTML><HEAD></HEAD><BODY><P>Hello Joe,</P><P>I'm afraid there's not. I don't have any personal edition available to make readable the file.</P><P>Anyway, it has the same code used in my previous posts here.</P><P>Regards.</P></BODY></HTML> Fri, 10 Dec 2010 11:45:14 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213293#M67059 Miguel_Angel_Baeyens 2010-12-10T11:45:14Z Top xxx based on Slider https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213294#M67060 <HTML><HEAD></HEAD><BODY><P>Hi Guys, this has helped me a lot thanks. I have built a slider to show sales for the top "vHowMany" customers, showing the data in a pivot table.</P><P>What I want to do now is add a new object (pie chart) at the bottom so that if you select the top "vHowMany" customers, it shows which products they have bought (i.e Dimension="Product", Expression="Sum(SALES)). However, because your example sets all other customers to "Other", the pivot chart shows product split for every customer (including "Other").</P><P>Do you know how to build the rank code into an expression, so that only the products bought by the top "vHowMany" customer show?</P><P>Thanks,</P><P>R</P></BODY></HTML> Tue, 14 Dec 2010 09:52:15 GMT https://community.qlik.com/t5/QlikView/Top-xxx-based-on-Slider/m-p/213294#M67060 2010-12-14T09:52:15Z