This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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!