topic Re: rookie question! in QlikView

rookie question!

Tue, 27 Aug 2013 15:42:15 GMT

I am playing around with straight tables and pivot tables today and I noticed that sometimes I have to click Show Partial Sums and other times I have to select Subtotals at Bottom. Can anyone explain the difference between the two?

I always manage to find my answer but logically I can't wrap my head around which one I use when, its always a 50/50 shot...

ROOKIE

Re: rookie question!

jagan — Tue, 27 Aug 2013 15:44:51 GMT

Hi,

SubTotals at bottom will display the totals on the bottom row and show partial sums is used for Pivot table total calculation upto the selected dimension level.

Regards,

Jagan.

Re: rookie question!

Gysbert_Wassenaar — Tue, 27 Aug 2013 15:56:28 GMT

Pivot tables and straight tables simply have different options. Pivot tables can have subtotals, straight tables only end totals.

In straight tables you can show only one totals row either on top or at the bottom. On the expressions tab you can set the Total mode per expression. On the Presentation you can choose between totals on top or at the bottom.

In pivot tables you can choose to show partial sums for each individual dimension and you can choose to show these totals on top or at the bottom. Both these settings can be set on the Presentation tab.

Re: rookie question!

Tue, 27 Aug 2013 16:11:52 GMT

Okay that makes sense, but I am looking at one of my pivot tables right now and show partial sums is grayed out for every dimension.

I have Subtotals at Bottom selected and it is working like Show Partial Sums (on each dimension) but that goes against your explanation above... I THINK!

Re: rookie question!

Gysbert_Wassenaar — Tue, 27 Aug 2013 16:20:59 GMT

Did you enable the Indent Mode option on the Style tab? That option will disable the partial sums.

Re: rookie question!

Tue, 27 Aug 2013 16:23:23 GMT

Ahh ha... Learn something new every day!

Thanks