Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeJones
Contributor III
Contributor III

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.