Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

deepaktibhe
Valued Contributor

Set analysis

I want to show sum of sales for top 20 city can you please tell me how to do that using set analysis

2 Replies
MVP
MVP

Re: Set analysis

Isn't this the same question as in your other thread? Please try to avoid duplicate posts.

Try

=sum({<City = {"=rank(sum(Quantity))<=20"}>} Quantity)

Not applicable

Re: Set analysis

Sum(Sales) in expression...

In Dimension limit tab--> Check limit the number of values to be shown

-->Choose show only--> Select Largest and give 20 as value