Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

deepaktibhe
Valued Contributor

Showing first n records

Hi All,'

Can you please suggest

how to show sum of quantity for first 20 city using rank function.

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: Showing first n records

Try (replacing City and Quantity with your field names):

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

3 Replies
MVP
MVP

Re: Showing first n records

Try (replacing City and Quantity with your field names):

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

selvakumarsr
Contributor

Re: Showing first n records

For simple way.. You can use Dimension Limit "Largest" 20.

selvakumarsr
Contributor

Re: Showing first n records

=aggr(if(Rank(total Sum(Quantity)=20, DimensionColumnName), DimensionColumnName)