top 20

[raadwiptec]

I have the following columns in my chart.

Customer name

Sales in Pounds

Product details

..

few other column

I need to have an option like slider or something else where i can take the top 20 or top 30 customer sorting from the highest in sales.

[MK_QSL]

Calculating TOP 10 VALUES in PIVOT TABLE

http://www.learnqlickview.com/a-qlikview-tip-how-to-display-top-n-and-bottom-n-values/‌

Top 10 rows and total of top 10

Qlikview Chart the Top 10 by RFB 28 - YouTube

[Anil_Babu_Samineni]

Try to create expression for top30, top20

Then use those variables from dropdown then x click top20 then see how associative

hope helps

[berkarmagan]

Create a variable which changing by your slider. And put that variable on Chart->Dimension Limits-> Show only-> Largest's value. I think it works for you.

[jagan]

Hi,

Create a slider and assign a variable(for example vTopN to that slider.

Now in your expression use like this

Dimension : Customer name

Expression: If(Rank(Sum(Sales)) <vTopN, Sum(Sales))

Now select Supress Null values option in Presentation tab.

Or you can also try Dimension Limits tab and just give vTopN

Hope this helps you.

Regards,

jagan.

[miguelbraga]

Hey there,

What chart you have? A pivot table or a straight table? If it is a pivot table then you don't have Dimensions Limit and must address the Top20 or Top30 in your expression, if it is a straight table you can work out in the Dimensions Limit.

Best regards,

Data Architect MB

[#7]

if you are using straight table you can use "Dimension limits" Tab any other you can use Rank function