topic Pivot table totals in QlikView

Pivot table totals

Tue, 24 May 2011 08:02:13 GMT

Hi All,

I have a dimension used to break my data in the pivot table.

For some of the breaks there is only one category is there a way to suppress creating a sub total for these?

The pivot looks like this:

category 1       xxx        £500
                      yyy        £200
                      zzz        £800

subtot £1500

category 2 aaa 100

subtot £100 - this is the subtotal I want to supress/hide

total £1600

Many thanks,

Phil

raghavsurya — Tue, 24 May 2011 08:17:20 GMT

Hi Phil,

According to my understanding, there no way you can hide subtotals for one category while displaying the other in Pivot table.

Regards,

Raghav

Tue, 24 May 2011 08:21:06 GMT

Hi Phil,

there is a way to do so:

If(Dimensionality()=1 and NoOfRows()=1,'', Sum(Amount))

as example!

Please see QV help to read more about the used inter-record functions.

Good luck!

Rainer

Tue, 24 May 2011 08:23:41 GMT

Hi Rainer,

Many thanks for that I'm giving it a go now

Phil

Tue, 24 May 2011 08:24:54 GMT

Thanks Raghav, for having a look - hopefully the answer from Rainer will do the trick.

Phil