topic partial sums in a pivot are wrong in QlikView

partial sums in a pivot are wrong

Fri, 01 Jul 2011 13:40:26 GMT

hi,

i have a pivot-chart, were are shown some data:

the total field is because of the check-box in presentation-tab, name and date are dimensions, value is a formula.

has anybody an idea to fix the problem?

danielrozental — Fri, 01 Jul 2011 13:53:46 GMT

You can correct this by using the AGGR funciton, you should look around the forum since this has been resolved several times already.

Fri, 01 Jul 2011 15:01:40 GMT

with aggregeation i can fill a new column with the partial sum, but i don't want to do this.

i used the search, keywords were 'partial sum pivot', but i can't find a solution.

thats why i asked

danielrozental — Fri, 01 Jul 2011 15:04:32 GMT

Can you post a sample app then? because I don't really understand what your problem is.

erichshiino — Fri, 01 Jul 2011 15:22:36 GMT

Hi,

The aggr expression would be something like:

sum ( aggr ( yourExpression, name, date))

but it may be good to take a look at your expression to understand what is going on...