Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
berndjaegle
Creator II
Creator II

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.Remove Patrial Sum.png

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


Cheers Bernd