topic Re: sub total pivot table in QlikView

sub total pivot table

jjking58 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

Can someone explain how to total the below pivot table example at the AcctPrefix

subtotal for 6 should be 13 , 7 should be 18 etc, I've tried using the sub total option under the presentation tab and it's not working

Thanks in advance

Re: sub total pivot table

MK_QSL — Wed, 21 Mar 2018 16:54:15 GMT

This should work

Go to presentation tab

Select your dimension and tick show partial sum

If this not work, then upload sample app to check!

Re: sub total pivot table

sunny_talwar — Wed, 21 Mar 2018 16:55:17 GMT

What expression did you use for AcctPrefix?

Re: sub total pivot table

ychaitanya — Wed, 21 Mar 2018 17:19:37 GMT

Navigate to Presentation Tab - > Select Dimension Level1 Desc-> Select Show Partial Sums.

Thanks

Re: sub total pivot table

jjking58 — Wed, 21 Mar 2018 18:01:24 GMT

AcctPrefix is a dimension not an expression. Partial sums does not work. See below

Re: sub total pivot table

ychaitanya — Wed, 21 Mar 2018 18:15:06 GMT

Navigate to Presentation Tab - > Select Dimension Level1 Desc-> Select Show Partial Sums.

Thanks

Re: sub total pivot table

MK_QSL — Wed, 21 Mar 2018 18:19:30 GMT

Provide sample app to check.. Otherwise difficult to answer based on screenshots.

Re: sub total pivot table

jjking58 — Wed, 21 Mar 2018 18:51:31 GMT

Guys ,

"select show partial sum" does not work on either dimension or a combination of both dimensions.

The only thing missing from the screen shots is an expression which is sum(amount)

Re: sub total pivot table

MK_QSL — Wed, 21 Mar 2018 19:17:42 GMT

I just tried with sample data like below and it's working.. we need your app to understand what is wrong..

Re: sub total pivot table

jjking58 — Wed, 21 Mar 2018 20:24:26 GMT

I recreated the pivot chart and used the "select show partial sum" on the Level1Desc and now it's working.

Not sure why, maybe i changed a setting while trying to get it to work that need to be set a certain way.

This time i took all the defaults.

Thanks again

Re: sub total pivot table

MK_QSL — Wed, 21 Mar 2018 20:30:32 GMT

glad that you got your solution. Please close the thread by selecting appropriate answer.

Re: sub total pivot table

ychaitanya — Wed, 21 Mar 2018 20:57:24 GMT

glad to know that.. as mentioned earlier "select show partial sum" on the Level1Desc will solve the issue