# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
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???

2 Solutions

Accepted Solutions
Champion III

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)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Partner
Author

Thankyou...

I have achieved with below expression

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

5 Replies
Creator III

Can you share your data with me.

MVP

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

Champion III

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)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
MVP

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
Author

Thankyou...

I have achieved with below expression

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