Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Partner
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???

1 Solution

Accepted Solutions
vinieme12
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
sarvesh
Contributor III

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

Can you share your data with me.

Highlighted

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?

vinieme12
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)

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

I would handle this a slight different way

Instead of this

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
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]))