Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
as i said you can change your expression by
=avg(aggr(TONEXPRESSION,Direction,Département))
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
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