topic Pivot table % in QlikView

Pivot table %

Thu, 16 Jun 2016 07:50:09 GMT

Hi everyone,

I need your help with pivot table calculations, especially percentages.

In the pivot table below, i need to calculate percentages for the "Libellé direction régionale" and every "Libellé groupe" in it.

The thing is the expression i used only works for the "Libellé direction régionale" and i can't figure out why.

Do you guys have an idea on how i should proceed ?

Thank you for your help.

Re: Pivot table %

Anil_Babu_Samineni — Thu, 16 Jun 2016 08:52:31 GMT

is there any chance to share the qvw for reference..!

¿hay alguna posibilidad de compartir el qvw para referencia ..!

Re: Pivot table %

Thu, 16 Jun 2016 09:05:36 GMT

Of course ! Here it is

Re: Pivot table %

sunny_talwar — Thu, 16 Jun 2016 09:32:19 GMT

What would be the expected output here? Would you be able to point that out in an Excel file may be?

Re: Pivot table %

Thu, 16 Jun 2016 09:46:06 GMT

Here is the expected output for April 2016, in an Excel file and in a qvw

Re: Pivot table %

sunny_talwar — Thu, 16 Jun 2016 13:50:13 GMT

I am not entirely sure how you reached to this calculation? Would you be able to point how the calculations are carried out?

Re: Pivot table %

Thu, 16 Jun 2016 14:01:44 GMT

The expression "Taux de mise en conformité" allows me to follow the "Clauses Ko restantes" 's progression since April 2015. This is how it is calculated :

(Clauses KO restantes April 2015 - Clauses KO restantes April 2016) / Clauses KO restantes April 2015

I hope this is clear enough for you, my english is not that good, sorry 🙂