topic Re: adding a column to existing pivot table. in QlikView

adding a column to existing pivot table.

marksmunich — Tue, 21 May 2013 15:31:02 GMT

I have a piviot table, i would like to create a new piviot table with an extra column, the data in a new table will be same as old with a new coulmn which will be a calcualted value. for example consider salary for working hours. one column already has data about the working hours, how can i calculate the pay per hour in the next column to it.

Re: adding a column to existing pivot table.

khadeer — Tue, 21 May 2013 15:40:14 GMT

Hi,

You have to add new dimension or calculated dimension to new pivot table.You have to add depend on your requirement.

Regards,

Khadeer

Re: adding a column to existing pivot table.

marksmunich — Wed, 22 May 2013 07:10:53 GMT

yeah i found the solution for it.

Re: adding a column to existing pivot table.

Tue, 23 Jul 2013 12:29:56 GMT

Please can you share?

Thanks

Re: adding a column to existing pivot table.

Tue, 23 Jul 2013 12:51:50 GMT

Thanks, But how do you add another column in a pivot table?

Re: adding a column to existing pivot table.

narender123 — Tue, 23 Jul 2013 13:00:20 GMT

If you want to add column then simple in dimention add column .if you want to add expression as mohit expression then add expression in expression.

Thanks

Re: adding a column to existing pivot table.

Tue, 23 Jul 2013 13:28:09 GMT

Thank you both very much. But in my pivot table i have a main heading which has sub-headings. I want to add a column to the end of my pivot table which contains, for each row, the sum of two of the columns divided by another column. Hown could I do this?

Thanks

Re: adding a column to existing pivot table.

narender123 — Tue, 23 Jul 2013 13:33:34 GMT

Hi,

Give me some example that what you want.

Thanks

Re: adding a column to existing pivot table.

Wed, 24 Jul 2013 08:33:40 GMT

Hi,

Thamks for your help.

At the moment I have the following pivot table:

Transport Type
Date	Car	Van	Cycle	Total
Jan-13	A1	B1	C1	Sum(A1:C1)
Feb-13	A2	B2	C2	Sum(A2:C2)
Mar-13	A3	B3	C3	Sum(A3:C3)
Apr-13	A4	B4	C4	Sum(A4:C4)
May-13	A5	B5	C5	Sum(A5:C5)
Jun-13	A6	B6	C6	Sum(A6:C6)
Jul-13	A7	B7	C7	Sum(A7:C7)

But I want to get:

Transport Type
Date	Car	Van	Cycle	Total	Car Proportion	Car and Van Proportion
Jan-13	A1	B1	C1	Sum(A1:C1)	A1/Sum(A1:C1)	(A1+B1)/Sum(A1:C1)
Feb-13	A2	B2	C2	Sum(A2:C2)	A2/Sum(A2:C2)	(A2+B2)/Sum(A2:C2)
Mar-13	A3	B3	C3	Sum(A3:C3)	A3/Sum(A3:C3)	(A3+B3)/Sum(A3:C3)
Apr-13	A4	B4	C4	Sum(A4:C4)	A4/Sum(A4:C4)	(A4+B4)/Sum(A4:C4)
May-13	A5	B5	C5	Sum(A5:C5)	A5/Sum(A5:C5)	(A5+B5)/Sum(A5:C5)
Jun-13	A6	B6	C6	Sum(A6:C6)	A6/Sum(A6:C6)	(A6+B6)/Sum(A6:C6)
Jul-13	A7	B7	C7	Sum(A7:C7)	A7/Sum(A7:C7)	(A7+B7)/Sum(A7:C7)

How could I do this?

Many Thanks.

Re: adding a column to existing pivot table.

Wed, 28 Aug 2013 06:30:22 GMT

Did u find the solution ? I do have the similar problem.Can you please help me out?

Re: adding a column to existing pivot table.

marksmunich — Mon, 02 Sep 2013 13:12:40 GMT

it is simple, just create a new Dimension or an Expression as a new field.. check out the above example, it is well explained. what all you Need is to add a new calculated Dimension or create a new Expression.

Re: adding a column to existing pivot table.

help — Wed, 19 Jun 2019 13:48:27 GMT

Did you find a solution? I'm trying to do a very similar thing to no avail.