topic Re: Pivot table % of Total in QlikView

Pivot table % of Total

Mon, 26 Apr 2010 16:37:21 GMT

How is a "% of total column" done in a pivot table?

I know how to do this using a straight table, but we need a pivot table.

The 1st column will be Product family,
the 2nd column will be Sum(Sales) and
the 3rd column will be % of total Sales.

Thanks

Pivot table % of Total

Mon, 26 Apr 2010 16:44:43 GMT

Hi danhilz,

You have to put in the expression of the third column:

Sum(Sales) / Sum(TOTAL Sales)

Maybe it works

Pivot table % of Total

pkelly — Mon, 26 Apr 2010 16:46:04 GMT

=Sum(Sales) / Sum(TOTAL Sales)

Think the above should work for you...

Pivot table % of Total

Mon, 26 Apr 2010 16:56:02 GMT

Thank worked.

Thanks.

Re: Pivot table % of Total

alwinsch — Fri, 23 Mar 2012 15:56:03 GMT

Hi,

Since i'm new to QV

and i found this correct answer... but unfortunately i doesn't work for me.

could you help me please?

I attached the QV document.

kind regards,

Alwin

Re: Pivot table % of Total

Fri, 23 Mar 2012 17:03:39 GMT

Hi Alwin,

Your code syntax was wrong, correct syntax attached

Regards

Kulbir

Re: Pivot table % of Total

alwinsch — Tue, 27 Mar 2012 06:38:59 GMT

Hi kulbir,

Sorry for my late response.

And first of all thanks for the help, but when i paste your syntax in my QVW file

it gives me an error:

=sum([Totaal v/h Jaar]) / sum(TOTAL [Totaal v/h Jaar])

It says that the Fieldname is not correct.

But it is correct!

Kind regards.

Alwin

Re: Pivot table % of Total

Tue, 27 Mar 2012 12:42:22 GMT

Alwinsch,

are you sure that you're not using the Label instead of the Field name as in the file you attached earlier? Try and open the Edit Expression dialog, and select the field you want to use in the drop-down list furthest down on the dialog, and hit the paste button where you want it to go.

Regards

Re: Pivot table % of Total

alwinsch — Tue, 27 Mar 2012 12:52:43 GMT

Fseijsing,

Yes i'm sure it is not in the label:

the label says : 'Aandeel in portefeuille '

I cannot select the fields, because it is already an expression.

I can type in the beginning of the expression and intellisense does the rest...

so i know it is the correct way to write the variable... because it is case sensitive

regards,

Re: Pivot table % of Total

alwinsch — Thu, 29 Mar 2012 13:38:44 GMT

Hi all,

I solved it!

Changed pivot table to a normal table

and then i could use the 'Relative' option.

Regards,

Alwin