Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeJones
Creator
Creator

Calculation of percentages in a pivot table

Hi, I have built a pivot table in Qlik Sense and introduced a count - count(FinalStatus) and I have asked the pivot table to show the total for the week and for the day.

I wish the pivot table to calculate the percentage of the total.  For example, in the total area completed would be 64%, whilst in Mon 7 Nov completed would be 61%.

Below shows what I am using currently.

PlannedDate.autoCalendar.Date Totals 07/11/2022
WeekDay(PlannedDate)   Mon Mon
FinalStatus Count count('FinalStatus')/count(Total<=[PlannedDate.autoCalendar.Date]>'FinalStatus') Count count('FinalStatus')/count(Total<=[PlannedDate.autoCalendar.Date]>'FinalStatus')
Totals 4673 - 916 -
Completed 3014 - 562 -
Rescheduled 239 - 73 -
Completed with issues 1099 - 202 -
Cancelled 321 - 79 -

 

 

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

remove the equal sign

 

count('FinalStatus')/count(Total<=[PlannedDate.autoCalendar.Date]>'FinalStatus')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

remove the equal sign

 

count('FinalStatus')/count(Total<=[PlannedDate.autoCalendar.Date]>'FinalStatus')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.