topic Re: add % column to the pivot table in QlikView

add % column to the pivot table

Tue, 16 Sep 2014 03:02:31 GMT

Hi,

Actually my problem is i have .qvd file data. data the used to generate the pivot table like this

month	lost	nodecision	won	grandtotal
jan	40	30	3	73
feb	45	35	4	84
mar	65	45	5	115
grandtotal	150	110	12	272

but i need this type

month	lost	nodecision	won	grandtotal	Rate%=won/Grandtota
jan	40	30	3	73	won/Grandtotal(3/73)
feb	45	35	4	84	won/Grandtotal(4/84)
mar	65	45	5	115	won/Grandtotal
grandtotal	150	110	12	272	won/Grandtotal

my using the this expression count({<status={'won'}>}[month])/count(status)

it will generate like this but i need only rate% column after the grand total only

month	lost		nodecision		won		grandtotal	Rate%
	grandtotal	Rate%	grandtotal	Rate%	grandtotal	Rate%
jan	40		30		3		73
feb	45		35		4		84
mar	65		45		5		115
grandtotal	150		110		12		272

any one plz help me urgent......

Re: add % column to the pivot table

ecolomer — Tue, 16 Sep 2014 03:32:07 GMT

See the file and image

Re: add % column to the pivot table

Tue, 16 Sep 2014 05:03:37 GMT

sorry I need only the rate%=won/grandtotal only after the grand total column.

please write the script in the discussion form only plz......

Re: add % column to the pivot table

jagan — Tue, 16 Sep 2014 05:21:57 GMT

Hi,

Create new expression

Rate % = Sum(won) / (Sum(won)+Sum(lost)+sum(nodecision))

Now in Number tab select Fixed to 1 or 2 (depends on your requirement) and select Show in % option.

Hope this helps you.

Regards,

Jagan.

Re: add % column to the pivot table

Tue, 16 Sep 2014 11:17:17 GMT

how to calculate won, lost, no decision all are the status column data.

Re: add % column to the pivot table

ecolomer — Tue, 16 Sep 2014 11:39:55 GMT

Here you have the image

Re: add % column to the pivot table

jagan — Wed, 17 Sep 2014 02:02:50 GMT

Hi,

Attach some sample data and your expected output, without proper info it is difficult to understand and give solution. If you want to get the count of won, lost, no decision then use count

Won - Count(won)

lost - Count(lost)

NoDecision - Count(Nodecision)

Rate % = Count(won) / (Count(won)+Count(lost)+Count(nodecision))

Hope this helps you.

Regards,

Jagan.