topic variable to display top customers in QlikView

variable to display top customers

Wed, 18 Aug 2010 10:25:38 GMT

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.

variable to display top customers

Wed, 18 Aug 2010 10:28:21 GMT

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

variable to display top customers

Wed, 18 Aug 2010 10:34:44 GMT

Hi Richard,

Maybe this post could help you.

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

Regards.

variable to display top customers

Wed, 18 Aug 2010 10:35:55 GMT

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.

variable to display top customers

Wed, 18 Aug 2010 10:49:54 GMT

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

variable to display top customers

Wed, 18 Aug 2010 10:54:00 GMT

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??

variable to display top customers

Wed, 18 Aug 2010 16:52:53 GMT

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.