Discussion Board for collaboration related to QlikView App Development.
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.
Try this expression
Sum(Hours)/Sum(TOTAL <[Resource Name]>Hours)
View solution in original post
Thanks Sunny...it worked!