Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
vijaymadhavan28
Contributor
Contributor

QlikView Pivot table to calculate percentage by row

Hi Experts,

I am experiencing a scenario where pivot table shows correct set of percentage values as shown in Screenshot (1) when I try to explore the placement ratio % of  (Days / Total) for an individual company. However, when I try to bring more companies into this table (Example: Top 3 companies), placement ratio percentage is getting calculated as "Day / Overall Total of submissions" as shown in Screenshot (2). 

I need placement ratio % to be calculated by row for each companies. Is this possible to implement here?

Screenshot (1):

vijaymadhavan28_0-1649351856025.png

Screenshot (2):

vijaymadhavan28_2-1649352081969.png

Looking forward for your comments.

 

 

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi

Hope this helps

For individual company, you need to use Total<Company> in ur expression instead of Total alone. 

Ex: Count(days) / Count(Total<Company> days)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

Hi

Hope this helps

For individual company, you need to use Total<Company> in ur expression instead of Total alone. 

Ex: Count(days) / Count(Total<Company> days)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.