variable to display top customers

[#1]

Hi Everyone,

I have 2 fields Customer and Sales,

there are 100 customers and their value. I want to create a flag that has to be a variable to display the top 10 customers according to their sales, it has to change according to my selection which is why it can't be a fixed flag.

Any Ideas?

Please let me know if i should send a demo model.

[#2]

It would be great if u send an example & explain them

[#3 · Accepted solution]

Hi Richard,

Maybe this post could help you.

http://community.qlik.com/forums/t/32457.aspx

Regards.

[#4]

Hi,

You can use a slider or input box and assign it to a variable (vDisplayTop).

In the chart 'properties>Presentation>Max visible numbers' include the variable (vDisplayTop) under the customer dimension.

Also, set the sorting of the 'Customer' dimension based on sales (y-value) in descending order.

When the user select 10 in slider or enters 10 in input box, only the top 10 customers will be shown in the chart. Similarly the top N will be displayed based on the variable value.

I hope this is what you expected.

[#5]

u can use a input box also for changing variable value.

[#6]

Hi, thank you all for your answers, some great ideas that i will use. But how would you go about creating a button that when you click, the top 10 customers based on their value are selected throughout the model instead of only one chart??

[#7]

Take a look at this: http://qlikviewmaven.blogspot.com/2010/07/ive-mentioned-several-times-kind-of.html

You may be able to put that kind of selection into an advanced search box. For some of my reports I've created a calculated dimension that only shows the top ten customers in a chart... then the user can select those customers easily by dragging her cursor over the ten customers in the chart.