Explain this one please

[#1]

Hai every one......Iam a new to Qlikview.............

I have Customer table in that table fields are

Customer,Product,Q1,Q2,Q3,Q4  

using this table find this........

1.find the top two products in each customer...

2.Finding the biggest customer for a quarter

3.Determining which customers purchase the most of each product.

Explain this one....

[maxgro]

here you can find a very detailed explanation

Show Top Performers

[#3]

I was written the code in Dimension tab like this.....

=Aggr(If(rank(sum([Qtr 3]),1)<=2,Product),Customer,Product)

but the result is displayed like This........

Customer   Product         Qtr3

alfki            chartreuse     543

                  product2        789

                  -----                905

total                                2209

like this  

here what is the third row in the product column....

Iam using Pivot table.

what is the code to display only two top Products From  Each Customer

[Nicole-Smith]

Click on the Product dimension, then click "Suppress When Value Is Null":