topic Re: Customize qlikview partial sum in QlikView

Customize qlikview partial sum

ArMehr — Sat, 16 Nov 2024 02:49:32 GMT

Hi.

I have a pivot table like this:

I want to show partial sum like this:

I would be very glad you could help me.

Re: Customize qlikview partial sum

Frank_Hartmann — Sat, 03 Aug 2019 12:24:16 GMT

Script:

1: LOAD * INLINE [ Customer, Client, Year, Qty Joe, Sweden, 2018, 10 Joe, Norway, 2018, 5 Joe, Sweden, 2019, 20 Joe, Norway, 2019, 10 John, Sweden, 2018, 5 John, Norway, 2018, 10 John, Sweden, 2019, 10 John, Norway, 2019, 20 Sarah, Sweden, 2018, 30 Sarah, Norway, 2018, 20 Sarah, Sweden, 2019, 40 Sarah, Norway, 2019, 60 ]; Island: Load * Inline [ Dim 1 2 ];

Pivot:

Dimensions:

=Pick(Dim,Client,'Total') =Year =Customer

Expression:

sum(Qty)

and only enable "Show Partial Sums" for Customer

Re: Customize qlikview partial sum

ArMehr — Sat, 03 Aug 2019 12:56:41 GMT

Thank you so much for your quick reply Frank, Could you just explain how it works?

Re: Customize qlikview partial sum

Frank_Hartmann — Sat, 03 Aug 2019 13:13:50 GMT

the pick dim expression just adds an Extra Row with Name 'Total' to field Client.

and in order to do that you need to crate an island table in script!