topic Re: Rank top 10 in Pivot Table (TCD) in QlikView

Rank top 10 in Pivot Table (TCD)

Mahmoud — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 07 Feb 2019 13:23:57 GMT

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 — Thu, 07 Feb 2019 13:39:24 GMT

Thank you, it works

Mahmoud — Thu, 07 Feb 2019 15:10:54 GMT

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

sunny_talwar — Thu, 07 Feb 2019 15:16:14 GMT

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 — Thu, 07 Feb 2019 15:18:38 GMT

thank you very much 🙂

Sue_Macaluso — Thu, 07 Feb 2019 20:59:01 GMT

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

Mahmoud — Fri, 08 Feb 2019 11:02:47 GMT

QlikView