topic Can a user remove 'show partial sum' for dimensions? in QlikView

Can a user remove 'show partial sum' for dimensions?

Thu, 10 Oct 2013 17:39:21 GMT

Hi,

I have several sheets that show employee statistics for date range. Each dimension (department, manager, month, etc) is set to show partial totals by default in the sheet. Is there a way to allow the user to toggle these totals on/off?

Re: Can a user remove 'show partial sum' for dimensions?

CELAMBARASAN — Thu, 10 Oct 2013 18:03:51 GMT

By using macros you can do

Below is sample

set chart = ActiveDocument.GetSheetObject("CH06")

set cp = chart.GetProperties

set dims = cp.Dimensions

dims(0).ShowPartialSums = false 'false - do not show sums, true - Show partial sum.

chart.SetProperties cp

Re: Can a user remove 'show partial sum' for dimensions?

Gysbert_Wassenaar — Fri, 11 Oct 2013 07:31:05 GMT

If you're using QV11 it's easier to add the dimension twice, once with partial sums enabled and once without, and use the conditional display expression to toggle between the two. See attached example

Re: Can a user remove 'show partial sum' for dimensions?

berndjaegle — Fri, 20 Nov 2015 09:29:36 GMT

Hi Brian,

I got it fixed with dimensionality().

Might not be a very dynamic solution, but it fixed my table.

The Total has two dimensons. These are the first two columns of my table. Please see png.

if (Dimensionality()=2, '',
sum(Material.GivAmount) * sum(Order.Amount)
)

Cheers Bernd