topic Re: add one more column to pivot table in QlikView

add one more column to pivot table

Mon, 15 Sep 2014 04:53:11 GMT

in pivot table I have won and total columns their I need to calculate the %column add to pivot table means won/total =% column how to calculate the % column after generate the pivot table

Re: add one more column to pivot table

tresB — Mon, 15 Sep 2014 04:59:54 GMT

=[LabelofOwnCol] / [LabelofTotalCol]

Then in the number tab, check 'Show in Percent(%)'

Re: add one more column to pivot table

Mon, 15 Sep 2014 05:03:35 GMT

in expression

= won / total

the proprties , number tab, check 'Show in Percent(%)'

Re: add one more column to pivot table

Mon, 15 Sep 2014 05:25:00 GMT

this is the pivot table

mnt status lst nd rec won total

jan 1 1 1 1 4

feb 1 2 1 2 6

after generate the pivot table like this than after add other column to the pivot like % column like won/total.

total column also one expression column.

Re: add one more column to pivot table

Mon, 15 Sep 2014 05:37:50 GMT

any one explain me...plz

Re: add one more column to pivot table

Mon, 15 Sep 2014 05:54:43 GMT

may this help you,

sum({<status={'won'}>}Value)/sum({<status={'total'}>}Value)

replace Value with your field..

Re: add one more column to pivot table

Mon, 15 Sep 2014 06:01:35 GMT

apply this one but the % column add every status column I need only one column after the total any one plz explain me

Re: add one more column to pivot table

SunilChauhan — Mon, 15 Sep 2014 06:07:32 GMT

column(m)/column(n) m is the no of won Column and n is no of total column

PS: first expression in chart is known as column(1) ,second is column(2)....so on

hope this helps

Re: add one more column to pivot table

Mon, 15 Sep 2014 06:14:47 GMT

could you post your sample application..

Re: Re: add one more column to pivot table

tresB — Mon, 15 Sep 2014 06:16:56 GMT

May be like attached sample?

Re: add one more column to pivot table

pradnyat — Mon, 15 Sep 2014 07:12:43 GMT

Hi,

Write column(4)/ column (5) in % column.

Hope this will give you right result.