Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahmoud
Partner - Contributor III
Partner - Contributor III

Rank top 10 in Pivot Table (TCD)

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.

Tableau.png

2 Solutions

Accepted Solutions
sunny_talwar

How about this

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

View solution in original post

sunny_talwar

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))

 

View solution in original post

7 Replies
sunny_talwar

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
Partner - Contributor III
Partner - Contributor III
Author

Thank you, it works 

Mahmoud
Partner - Contributor III
Partner - Contributor III
Author

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

Tableau.png

sunny_talwar

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
Partner - Contributor III
Partner - Contributor III
Author

thank you very much 🙂

Sue_Macaluso
Community Manager
Community Manager

Is this for QlikView or Qlik Sense? I'd like to move it over to the appropriate product forum.
Sue Macaluso
Mahmoud
Partner - Contributor III
Partner - Contributor III
Author

QlikView