Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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

yashcena
Contributor III
Contributor III
Author

Thanks Sunny...it worked!