Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nesonica
Contributor III
Contributor III

Show top 3 values per first dimension

Hi guys,

I am failing at building the TOP3-dimension with the formula  

=If(Rank(Sum(TOP3-Category)) <=3, Sum(TOP3-Category))

as it would take ages to process all values. The plan is a table like this here:

 

CustomerTOP3-CategorySales
AZ500
AY300
AX200
BX400
BW350
BZ50
CY1000
CZ200
CX100

 

Thanks in advance! Best regards.

Nes

Labels (4)
1 Solution

Accepted Solutions
asinha1991
Creator III
Creator III

create a straight table or pivot chart with two dimension

1. Customer

2.=aggr(if(rank(sum(sales))<=3,[Category]),[Customer],[Category])  (make sure field names are correct)

 

In expression

add your measure(sum(sales) for example)

View solution in original post

4 Replies
asinha1991
Creator III
Creator III

put the second calculated dimension as

 

=aggr(if(rank(sum(sales))<=3,[Category]),[Customer],[Category])

asinha1991
Creator III
Creator III

attaching qvw, i used your data set and showed top 2 out of it, look at the top 2 pivot in qvw

nesonica
Contributor III
Contributor III
Author

thanks so much but unfortunately i have no permission qvw. could you please explain? 🙂
asinha1991
Creator III
Creator III

create a straight table or pivot chart with two dimension

1. Customer

2.=aggr(if(rank(sum(sales))<=3,[Category]),[Customer],[Category])  (make sure field names are correct)

 

In expression

add your measure(sum(sales) for example)