Pivot sum incorrect ?

[#1]

Hi community,

I have a sum problem and do not understand the result in my pivot table.

If my pivot table is expanded my values match and the partial sums is correct. But if i collape the pivot table, a wrong sum is calculated.

See Screenshot :

Thank you !

[#2]

and here the qlikviewfile.

Thank you for any help.

[#3 · Accepted solution]

the problem is the null value you have in Kostengruppeneu. Try with this formula:

Sum ({<Kostengruppeneu={*}>}[Wert/Bwähr_neu])

[#4]

Might also try RangeSum([Wert/Bwahr_nue])

[#5]

Hi dragonauta,

thank you for your help. By the way, what does the star {*} mean ?

thank you again.

Best regards,

[nathanfurby]

Are you saying that this statement worked for you?

Can you please post the working example - it does not work when I used it in your original qvw file.

[#7]

hi,

here the solution from dragonauto. I take the changes to my modified app:

do not forget to deactivate the null values from dimension !

[nathanfurby]

Thanks Honour.

So Dragonauta - why does QV not like the expression? It shows as an error in my v9 SR4 - but still calculates correctly.

Also - what exactly does the asterix in the set statement do? Is it selecting all non-null values?

Many thanks in advance.