topic Re: Top 5 in QlikView

Top 5

Mon, 18 Jun 2012 20:02:39 GMT

i have data for sales and i m using server10.

i want to show sum of sales in chart but only top 5 sales.

Top 5 sales are changed regularly on the basis of sales.

i want to know how to show top 5 sales on bar chart on monthly basis.

Re: Top 5

m_woolf — Mon, 18 Jun 2012 20:03:58 GMT

You should search for your issue before posting.

Re: Top 5

Anonymous — Mon, 18 Jun 2012 20:15:19 GMT

sort them by there values and limit the no data points to be shown in presentation tab

Re: Top 5

Mon, 18 Jun 2012 20:27:09 GMT

i need any micro or button by using that i will get top 5 values on charts .

there may be more than one chart and may be expression like sum(sales).

sum(visits) or sum(dl). and dimension also different.

Re: Top 5

sivarajs — Tue, 19 Jun 2012 10:21:49 GMT

create a variable like top,then create a input box with top variable

use the same variable in (maximum visible) presentation tab of chart properties e.g =top

If you enter values in input box it shows the charts accordingly

Re: Top 5

Tue, 19 Jun 2012 11:06:32 GMT

Hi,

First create a variable eg. vTopX.

then Create a Input Box eg.TopN and use this variable in this Input Box.

After this In your charts, Sort the values on YAxis.

thn in the Presentation Tab chk(Tick) the "Max Visible Number (1-100)" in "Dimension Limitation" and put the Name of the Variable in the "Max Visible Number (1-100)" eg. =vTopX.

Also chk(tick) the option in Presentation tab "Show X Axis Scrollbar"