topic Re: Changing the pivot table values into percentage values in QlikView

Changing the pivot table values into percentage values

mohanrajsubrama — Mon, 31 Dec 2012 11:16:25 GMT

Hi Guys,

I Have a Pivot table Of these columns.i have data's in values .

Country	Female	male	total
Albania	45	52	97
Algeria	154	542	696
American Samoa	436	481	917
Andorra	28	41	69

As per Client requirements there should be a list box or button with 2 options like values and percentage.So they can view their data in which format they like .

If we select percentage from list box The data should be in this format.

Country	Female	male	total
Albania	46.4	53.6	97
Algeria	22.1	77.9	696
American Samoa	47.5	52.5	917
Andorra	40.6	59.4	69

Any Suggestion about this.

Regards,

Mohanraj Subramanian.

Re: Changing the pivot table values into percentage values

Siva_Sankar — Mon, 31 Dec 2012 12:08:58 GMT

Mohanraj, Find the attached qvw file it will help. Regards. siva sankar k

Re: Changing the pivot table values into percentage values

mohanrajsubrama — Tue, 01 Jan 2013 05:50:03 GMT

Hi Shankar,

Thanks for Quick Response .I saw the qvw file what u made in Expression part and setting up variable.

But in my case Gender is the single column and male and female are in rows .i drageed it to the header part and made it to be two different columns.So i want to make some changes inthe expression part?

And same variable will it work for different reports ?Because i need to show them all the reports with the values and percentage wise.

Regards,

Mohanraj Subramanian