Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

3 Replies
Not applicable

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

Hello,

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

Thanks,

Angad

Not applicable

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

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

Not applicable

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

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.