topic Pivot sum incorrect ? in QlikView

Pivot sum incorrect ?

Fri, 15 Apr 2011 18:19:31 GMT

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 !

Fri, 15 Apr 2011 18:34:19 GMT

and here the qlikviewfile.

Thank you for any help.

Fri, 15 Apr 2011 18:59:45 GMT

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

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

Fri, 15 Apr 2011 19:27:42 GMT

Might also try RangeSum([Wert/Bwahr_nue])

Mon, 18 Apr 2011 11:42:39 GMT

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

thank you again.

Best regards,

nathanfurby — Mon, 18 Apr 2011 14:05:13 GMT

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.

Mon, 18 Apr 2011 15:49:21 GMT

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 — Mon, 18 Apr 2011 17:00:39 GMT

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.