Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
yashcena
Contributor III
Contributor III

Show Percentage in Pivot table

I have the following data in my data model:

Capture.JPG

I have created a pivot chart:

Capture2.JPG

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.

1 Solution

Accepted Solutions
sunny_talwar

Try this expression

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


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Try this expression

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


Capture.PNG

View solution in original post

yashcena
Contributor III
Contributor III
Author

Thanks Sunny...it worked!