topic Re: Aggregated Function Does Not Sum Up in QlikView

Aggregated Function Does Not Sum Up

Thu, 13 Feb 2014 14:41:05 GMT

Hi,

I had a similar question up yesterday. I have an app with a Pivot table that divides cases into ages. However when i collapse the table the sums does not add up?!? Naturally I would like the totals to add up on each row. i would like the individual ages to be added up as well. I have also noticed that if there are mote than one row on the same instance then the total does not add up.

Any ideas?

Cheers,

Re: Aggregated Function Does Not Sum Up

Nicole-Smith — Thu, 13 Feb 2014 14:43:37 GMT

You shouldn't be using aggr() like that in your expressions. Group and Name are already dimensions on the chart, so aggr() isn't needed. Take it off of your expressions, and it should work like you expect it to.

Re: Aggregated Function Does Not Sum Up

Thu, 13 Feb 2014 14:49:03 GMT

I need the aggr() function in order for the chart to display the partial sums. This is sort of the whole idea of the chart

Re: Aggregated Function Does Not Sum Up

Nicole-Smith — Thu, 13 Feb 2014 14:57:37 GMT

I don't understand what you mean, because it works for me without the aggrs() (the partial sums work too).

See attached.

Re: Aggregated Function Does Not Sum Up

Thu, 13 Feb 2014 15:07:52 GMT

nice! thanks! i didnt get my count functions to work - thats why i used a aggr function.