topic subtotal and total for pivot table in QlikView

subtotal and total for pivot table

Mon, 03 Oct 2011 13:17:56 GMT

Hello!

I would like to sum all the values in a column in a pivot table.

It's possible for simple tables using the Chart Properties> Expressions> Totals> sum of lines but for pivot table i don't know how to do...
I've tried using the Chart Properties> Presentation> SubT otals, but the results are false...

I put an Excel file attachment. There are comments on some cells.

Thanks a lot for your help

subtotal and total for pivot table

SunilChauhan — Mon, 03 Oct 2011 13:22:10 GMT

try this

Chart Properties> Expressions> Totals>

Rangesum(fieldName,1,noofrows())

subtotal and total for pivot table

kaushiknsolanki — Mon, 03 Oct 2011 13:31:04 GMT

HI,

You can try below expression.

if(sum(ACTIF_NET_GLOBAL)=0,sum(LAST_ACTIF_NET_GLOBAL), sum(ACTIF_NET_GLOBAL))

In your pivot chart.

Regards,

Kaushik Solanki

Re: subtotal and total for pivot table

Mon, 03 Oct 2011 13:31:38 GMT

@Sunil Chauhan

i would try but i don't understand...where can i put this expression?

When i use a pivot table, i have only the choice between : "no total", "total expression", or "sum of lines" in the box TOTALS.

subtotal and total for pivot table

SunilChauhan — Mon, 03 Oct 2011 13:37:03 GMT

first write your actual fieldname u want

and then

type this in expression

if( dimensionality()=0,

Rangesum(fieldName,1,noofrows()),sum(fieldName))

Re: subtotal and total for pivot table

Mon, 03 Oct 2011 13:37:55 GMT

hi,

thanks for yours answers..

i tried : if(sum(ACTIF_NET_GLOBAL)=0,sum(LAST_ACTIF_NET_GLOBAL), sum(ACTIF_NET_GLOBAL))

but i've the same result...

Re: subtotal and total for pivot table

Mon, 03 Oct 2011 13:44:01 GMT

ok thanks for explanations...

I tried

if( dimensionality()=0,

Rangesum(fieldName,1,noofrows()),sum(fieldName))

but...i've the same result with this expression

subtotal and total for pivot table

kaushiknsolanki — Mon, 03 Oct 2011 13:49:29 GMT

Hi,

Can you upload the sample file.

Regards,

Kaushik Solanki

subtotal and total for pivot table

SunilChauhan — Mon, 03 Oct 2011 13:51:54 GMT

first convert pivot into straight

then go to expression and check sum of rows

then again cconvert into pivot table

go to presentation-> show partial sum-> subtotal on top

hope you require this

Re: subtotal and total for pivot table

Mon, 03 Oct 2011 15:33:24 GMT

i've tried this solution but it doesn't work! ^^ thanks...

subtotal and total for pivot table

Mon, 03 Oct 2011 15:39:32 GMT

Kaushik Solanki a écrit:
Hi,
Can you upload the sample file.
Regards,
Kaushik Solanki

I added it on my first message...

Re: subtotal and total for pivot table

kaushiknsolanki — Tue, 04 Oct 2011 06:09:21 GMT

Hi,

Have a look at the attched document.

Regards,

Kaushik Solanki

Re: subtotal and total for pivot table

Thu, 06 Oct 2011 12:43:42 GMT

It works!!!

Thanks a lot