topic Re: Total SUM calculation for multiple expression under one dimension in QlikView

Total SUM calculation for multiple expression under one dimension

anatle1234 — Sun, 10 Dec 2017 08:46:52 GMT

hi,

I am trying to add total column to this pivot table:

as you can see in the total column I have # customer=3 although it should be 5, since we have 2 in first column and another 3 in last column. so can someone advise me how to calculate the total sum?

I currently checked the 'show partial sums' under PTD dimension.

and also is it possible to give the user option to sort based on all the expression he wants by clicking on it (like #cusomers, #of sites, etc...)?

I am new to QV...

THANKS.

Re: Total SUM calculation for multiple expression under one dimension

settu_periasamy — Sun, 10 Dec 2017 10:41:03 GMT

Can you provide your expression?

may be try with aggregation. Like

sum(aggr(your current expression),your current dimesnsions))

Re: Total SUM calculation for multiple expression under one dimension

sunny_talwar — Sun, 10 Dec 2017 13:01:57 GMT

You can also check here

Sum of rows in pivot tables ‒ QlikView

Re: Total SUM calculation for multiple expression under one dimension

uacg0009 — Mon, 11 Dec 2017 05:22:03 GMT

Hi Anat,

If you can give some example data, it will be better.

For now, I think the reason you can 3 in total is you use the count(distinct customer).

And for the first PTD, maybe you have customer A and B.

And for the second PTD, you have customer A and B and C.

So the total will be 3, because you only have A and B and C. I think that's reasonable.

And if you want to change it to 5. I think you can use count(customer). But you need to make sure that you won't have redundant data in your source table.

Thanks.

Aiolos