# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Partner

## display only top 20 -20 in a table based on a expression

Hi all,

I have a requirement to show top 10 accounts by sales in a table.(Done using Dimension limits)

I have to show the top 11-20 in another table.

I would need these 2 tables as i have to pull them into 2 different slides using N printing.

Could any one help me  on how to show top 11-20 account based on sales in a seperate table in qlikview???

Tags (4)
1 Solution

Accepted Solutions
Esteemed Contributor II

## Re: display only top 20 -20 in a table based on a expression

Remove Dimension Limits from both Tables

Add Set analysis to expression as example

for 1 -10

sum({<Account={"=rank(sum(Sales),1,1)<=10"}>} Sales)

for 11-20

sum({<Account={"=rank(sum(Sales),1,1)>10"}>*<Account= {"=rank(sum(Sales),1,1)<=20"}>} Sales)

5 Replies
Highlighted
Contributor III

## Re: display only top 20 -20 in a table based on a expression

Can you share your data with me.

MVP

## Re: display only top 20 -20 in a table based on a expression

May be using Rank() function... what is your expression and what all dimensions do you have?

Esteemed Contributor II

## Re: display only top 20 -20 in a table based on a expression

Remove Dimension Limits from both Tables

Add Set analysis to expression as example

for 1 -10

sum({<Account={"=rank(sum(Sales),1,1)<=10"}>} Sales)

for 11-20

sum({<Account={"=rank(sum(Sales),1,1)>10"}>*<Account= {"=rank(sum(Sales),1,1)<=20"}>} Sales)

MVP

## Re: display only top 20 -20 in a table based on a expression

I would handle this a slight different way

sum({<Account={"=rank(sum(Sales),1,1)>10"}>*<Account= {"=rank(sum(Sales),1,1)<=20"}>} Sales)

I would use this

sum({<Account={"=Rank(Sum(Sales),1,1) > 10 and Rank(sum(Sales),1,1) <= 20"}>} Sales)

Result wise no difference, but I feel its easier to read

Partner

## Re: display only top 20 -20 in a table based on a expression

Thankyou...

I have achieved with below expression

if(Rank(Sum([Field]))<=30 and Rank(Sum([field]))>20, sum([field]))