Rank top 10 in Pivot Table (TCD)

[Mahmoud]

Bonjour, 

I am new to qlikView, I have a PivotTable and I want to show the first ten lines, I added this expression:

=if((rank(sum({<Mouvement_ID={'VC'}>}Total_Net_HT))<=10), sum({<Mouvement_ID={'VC'}>}Total_Net_HT))

My problem is that it shows me the top ten for each column, and for my result I must have only the top ten according to the first column.

Thank you.

[sunny_talwar · Accepted solution]

How about this

=If(Rank(Sum(TOTAL <Article> {<Mouvement_ID = {'VC'}, Groupe = {'Global'}>} Total_Net_HT)) <= 10,
Sum({<Mouvement_ID = {'VC'}>} Total_Net_HT))

[Mahmoud]

Thank you, it works 

[Mahmoud]

I wanted to add two columns 'Produit' and  'Auteur' but I lost the selection and he shows me the whole table

[sunny_talwar · Accepted solution]

May be try this

=If(Rank(TOTAL Sum(TOTAL <Article> {<Mouvement_ID = {'VC'}, Groupe = {'Global'}>} Total_Net_HT)) <= 10,
Sum({<Mouvement_ID = {'VC'}>} Total_Net_HT))

[Mahmoud]

thank you very much 🙂

[Sue_Macaluso]

Is this for QlikView or Qlik Sense? I'd like to move it over to the appropriate product forum.

[Mahmoud]

QlikView