topic Re: aggregate the column values in QlikView

aggregate the column values

soniasweety — Sat, 16 Nov 2024 04:03:06 GMT

Hi all,

i have a column in pivot table product% it is showing % correct

but i need to show that total aggregating all columns values /no of rows .

how to achieve this?

Re: aggregate the column values

jonathandienst — Tue, 26 Mar 2019 08:40:01 GMT

I suggest you post some sample data and your required output to better explain your requirements. Post as text, not as images and you will get more relevant and accurate responses.

Re: aggregate the column values

soniasweety — Wed, 27 Mar 2019 09:26:31 GMT

HI Jontydkpi

attached sample

Re: aggregate the column values

sunny_talwar — Tue, 26 Mar 2019 12:55:12 GMT

What is your expression that you are using for Product%?

Re: aggregate the column values

soniasweety — Wed, 27 Mar 2019 09:25:51 GMT

Hi @sunny_talwar

below is the used expression

=()

Re: aggregate the column values

sunny_talwar — Tue, 26 Mar 2019 17:04:54 GMT

May be try this

((Sum(Total(Aggr(fabs(sum(FC_QT)-sum(AP_QT)),ID)))*sum(AP_QT))/sum(total AP_QT))
/
Count(DISTINCT id)

Re: aggregate the column values

soniasweety — Wed, 27 Mar 2019 08:58:50 GMT

its worked thank you 🙂