topic Re: SubTotal in pivot table in QlikView

SubTotal in pivot table

lessassy — Sat, 16 Nov 2024 19:03:54 GMT

Hello everyone all,



I have the following table:




It is a pivot table.

In the sub-total section, I would like to add the percentages instead of adding the percentages, while keeping the direction column.

Because I know that I can achieve the average by removing this column but I would prefer to find another solution.

Thank you in advance.

Re: SubTotal in pivot table

Taoufiq_Zarra — Fri, 21 Feb 2020 15:11:54 GMT

as i said you can change your expression by

=avg(aggr(TONEXPRESSION,Direction,Département))

Re: SubTotal in pivot table

lessassy — Fri, 21 Feb 2020 16:10:41 GMT

Thank you,

It works if i have only keep one dimension "Departement"

But if i add the other dimension "Direction" I don't have the nulber i want

Re: SubTotal in pivot table

Brett_Bleess — Wed, 25 Mar 2020 20:50:18 GMT

I suspect the following Design Blog post may get you what you need or on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett