Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)