Show Partial Sums not calculating data fully

[tinkerz1]

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 -

[Gysbert_Wassenaar]

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.

[tinkerz1]

,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

[Kushal_Chawda]

try,

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

[tinkerz1]

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

[tinkerz1]

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

[tinkerz1 · Accepted solution]

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

THis works, thanks all.

[Kushal_Chawda]

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