Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mohanrajsubrama
Contributor II
Contributor II

Changing the pivot table values into percentage values

Hi Guys,

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

CountryFemale male total
Albania455297
Algeria154542696
American Samoa436481917
Andorra284169

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.

CountryFemale male total
Albania46.453.697
Algeria22.177.9696
American Samoa47.552.5917
Andorra40.659.469

Any Suggestion about this.

Regards,

Mohanraj Subramanian.

2 Replies
Siva_Sankar
Master II
Master II

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

mohanrajsubrama
Contributor II
Contributor II
Author

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