topic Re: show partial sum display wrong result Y????????????? in QlikView

show partial sum display wrong result Y?????????????

Mon, 28 Jul 2014 12:07:17 GMT

Re: show partial sum display wrong result Y?????????????

Mon, 28 Jul 2014 12:10:56 GMT

Hello,

Can you please attach a sample file with this case. I have not seen such case earlier.

Thanks,

Angad

Re: show partial sum display wrong result Y?????????????

Mon, 28 Jul 2014 12:54:36 GMT

Hi Shweta,

I would take a look at your data model, the sub total will be the based on the expression total for that dimension. If you have data that is against multiple values of your dimension, the value will show against each of them but the overall sub total will only be based on the expression and count once.

Hope that makes sense

Joe

Re: show partial sum display wrong result Y?????????????

Mon, 28 Jul 2014 13:05:46 GMT

Hi,

You may need to aggregate by your dimension.

Ex. if your expression was sum(Field), it would become sum(aggr(sum(Field), Dimension))

In this way, your partial sums will be equal to the sum of each line.

If you're using a straight table, you have an alternative to keep the same expression and under the Expressions tab select your expression then select the 3rd option in the "total mode" and choose "sum" of rows.

Hope this helps.