Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

2 Solutions

Accepted Solutions
vinieme12
Champion III
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.

View solution in original post

nishanthlm
Partner
Partner
Author

Thankyou...

I have achieved with below expression

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

View solution in original post

5 Replies
sarvesh
Creator III
Creator III

Can you share your data with me.

sunny_talwar

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

vinieme12
Champion III
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.
sunny_talwar

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

nishanthlm
Partner
Partner
Author

Thankyou...

I have achieved with below expression

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