topic Re: top 20 in QlikView

top 20

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: top 20

MK_QSL — Tue, 20 Sep 2016 08:17:13 GMT

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

Re: top 20

Anil_Babu_Samineni — Tue, 20 Sep 2016 08:35:42 GMT

Try to create expression for top30, top20

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

hope helps

Re: top 20

berkarmagan — Tue, 20 Sep 2016 08:51:09 GMT

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.

Re: top 20

jagan — Tue, 20 Sep 2016 09:10:28 GMT

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.

Re: top 20

miguelbraga — Tue, 20 Sep 2016 09:10:55 GMT

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

Re: top 20

Tue, 20 Sep 2016 09:29:23 GMT

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