topic Pivot Table Partial Totals Incorrect & Selection Issue in QlikView

Pivot Table Partial Totals Incorrect & Selection Issue

bxprokop — Mon, 09 Jan 2017 22:06:27 GMT

Hi Qlik Community,

Question 1: I am running into an issue with the partial total in my pivot table in the attached file. The issue is related to the "Adjusted Reimb" and "Opportunity". These totals do not have the correct total. Can anyone provide guidance on the correct formula to get this to work? I will need the correct subtotal to show up when collapsed as well.

Question 2: In addition to that issue, I am also struggling with the Selection. When I make a select for Provider, Service Group etc. everything is still left in place. I know this is due to the Alternate State in place for the National Benchmark: %-To-Total. Is there any method that can be used so it only show what is being selected. Hopefully, that makes sense.

Any help would be greatly appreciated.

Thanks

Brian

Re: Pivot Table Partial Totals Incorrect & Selection Issue

sunny_talwar — Mon, 09 Jan 2017 22:56:54 GMT

Try the attached

Re: Pivot Table Partial Totals Incorrect & Selection Issue

bxprokop — Tue, 10 Jan 2017 01:35:36 GMT

That worked. Thanks

Re: Pivot Table Partial Totals Incorrect & Selection Issue

bxprokop — Tue, 10 Jan 2017 22:39:21 GMT

What did you do to address Question 2? I can't seem to replicate.

In the Analysis before your modifications, if I select a SERVICE GROUP it left behind all the other service groups as seen below

After the changes, it leave behind only the select SERVICE GROUP (which is what I was looking for)

QlikView App Development

Re: Pivot Table Partial Totals Incorrect & Selection Issue

sunny_talwar — Tue, 10 Jan 2017 23:29:33 GMT

I made 2 changes

1) Changed the expression for National Benchmark: %-To-Total

Sum({National}QUANTITY)/sum({National}TOTAL <[SERVICE GROUP]> QUANTITY) * Avg(1)

2) Checked 'Suppress Zero-Values' on the presentation tab of chart properties