topic Re: Show Partial Sums not calculating data fully in QlikView

Show Partial Sums not calculating data fully

tinkerz1 — Wed, 28 Oct 2015 12:24:08 GMT

Hi,

In my pivot table the format for numbers in Data(numeric) and right is selected, all my numbers are following this pattern, so I assume they are numbers,

But show partial sums are blank.

my formula is

=if([Data group]='Item Total',[Status_Count],If([Data group]='THold',[Threshold Data]))

Any ideas, if I use Num() still nothing

What is strange is its calculating data that is on its own in a row but not more that one

This will work, but not sure if its a calculation.

DATE

A 1

B -

C -

Total 1

This will not calculate

DATE

A 1

B -

C 1

Total -

Re: Show Partial Sums not calculating data fully

Gysbert_Wassenaar — Wed, 28 Oct 2015 12:44:25 GMT

I think that your if statement can't be calculated at the total level in the second case. But it's totally unclear to me what your pivot table uses as data and which dimensions and expressions you're using in it. Perhaps you can post a small qlikview document that demonstrates the problem.

Re: Show Partial Sums not calculating data

tinkerz1 — Wed, 28 Oct 2015 12:51:19 GMT

,If([Data group]='THold',sum([Threshold Data])))

I think I see it now, the above statement os for a group of data, so when I use just [Threshold Data] it shows one item.

if I sum then I get a a larger figure, so its something like Max, but this also will not sum at the partial expression

Re: Show Partial Sums not calculating data fully

Kushal_Chawda — Wed, 28 Oct 2015 13:03:28 GMT

try,

sum(if([Data group]='Item Total',[Status_Count],If([Data group]='THold',[Threshold Data])))

Re: Show Partial Sums not calculating data fully

tinkerz1 — Wed, 28 Oct 2015 13:17:41 GMT

Thanks, sum() grouped the data but Max() worked

Re: Show Partial Sums not calculating data fully

tinkerz1 — Wed, 28 Oct 2015 13:46:33 GMT

When you use MAX() the partial sum also finds the max not the total of the MAX's per line.

I dont see anything to code to be able to have sum of max's

Re: Show Partial Sums not calculating data fully

tinkerz1 — Wed, 28 Oct 2015 13:52:10 GMT

sum(distinct if([Data group]='Item Total',[Status_Count],If([Data group]='THold',[Threshold Data])))

THis works, thanks all.

Re: Show Partial Sums not calculating data fully

Kushal_Chawda — Wed, 28 Oct 2015 13:57:27 GMT

Please mark the correct or helpful answers and close the thread.