Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

top 20

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.

6 Replies
Highlighted

Re: top 20

Try to create expression for top30, top20

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

hope helps

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

Re: top 20

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.

Highlighted
MVP & Luminary
MVP & Luminary

Re: top 20

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.

Highlighted
Specialist III
Specialist III

Re: top 20

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

Highlighted
Not applicable

Re: top 20

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