Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. 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)

View solution in original post

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.

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)

View solution in original post

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