Discussion board where members can get started with QlikView.
I have the following columns in my chart.
Sales in Pounds
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.
Calculating TOP 10 VALUES in PIVOT TABLE
Top 10 rows and total of top 10
Qlikview Chart the Top 10 by RFB 28 - YouTube
Try to create expression for top30, top20
Then use those variables from dropdown then x click top20 then see how associative
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.
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.
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.
Data Architect MB
if you are using straight table you can use "Dimension limits" Tab any other you can use Rank function