topic Re: Pivot table, Partial sums , highest value, Total not working in QlikView

Pivot table, Partial sums , highest value, Total not working

separerl — Fri, 24 Jan 2025 19:39:44 GMT

Hi !

I am trying to create a Chart Pivot Table with partial sums
The highest value of Units are those who are interesting

As the Expression I use:
if(Units = Max(TOTAL <[User],[Company]> Units), Units, 0)

It works fine with setting 0 value on those rows who has lower value that the highest , but the show partial sums does not work
How should I solve this ?

The raw data , with and ordinary sum(Units) is working fine

I enclose a Qlikview sample problem file

Re: Pivot table, Partial sums , highest value, Total not working

anat — Sat, 25 Jan 2025 05:22:00 GMT

Use aggr function like

Sum(if(Units = Max(TOTAL <[User],[Company]> Units), Units, 0))

Re: Pivot table, Partial sums , highest value, Total not working

rubenmarin — Sat, 25 Jan 2025 08:37:31 GMT

Hi, using just [Units] in subtotals won't work if there are more than one value, in that case [Units] will be null, as no aggregation is specified.

Maybe with this expression:

Sum(Aggr(Max(TOTAL <[User],[Company]> Units),User,Company))

Re: Pivot table, Partial sums , highest value, Total not working

separerl — Sat, 25 Jan 2025 09:43:32 GMT

Hi !
Thanks very much for reply.
When applying the expression , I get correct sum for the Company level , but per User, it still does not calculate right

Re: Pivot table, Partial sums , highest value, Total not working

separerl — Sat, 25 Jan 2025 09:47:46 GMT

Forget the last posting , incorrect by me. It works with the suggested solution