Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | - |
remove the equal sign
count('FinalStatus')/count(Total<=[PlannedDate.autoCalendar.Date]>'FinalStatus')
remove the equal sign
count('FinalStatus')/count(Total<=[PlannedDate.autoCalendar.Date]>'FinalStatus')