topic Re: Show Percentage in Pivot table in QlikView

Show Percentage in Pivot table

yashcena — Wed, 03 Oct 2018 10:04:59 GMT

I have the following data in my data model:

I have created a pivot chart:

I want to add one more expression which will show percentage of hours spent on each project.

For AA, time spent on P1 is 20/100=20%, on P2 is 40/100=40%.

What expression should I use to show percentage? There is relative option for expressions in Pie-chart. I was wondering if we have a similar option in Pivot Tables. i have attached a sample app here.

Re: Show Percentage in Pivot table

sunny_talwar — Wed, 03 Oct 2018 10:21:07 GMT

Try this expression

Sum(Hours)/Sum(TOTAL <[Resource Name]>Hours)

Re: Show Percentage in Pivot table

yashcena — Wed, 03 Oct 2018 10:33:04 GMT

Thanks Sunny...it worked!