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: 
Anonymous
Not applicable

Show Total and Average in pivot table or straight table

I would like to create a table that displays information like this:

EmployeeCalls MadeSales MadeSales from Calls
Average10438.61%
Total3012---
Annie

10

220.00%
Bianca12758.33%
Charlie8337.50%

This is a simple task in Excel, but I cannot figure out how to do this in Qlik Sense. There are several challenges here:

  • The most important thing is that there doesn't seem to be an option to do multiple totals lines, one for Total and one for Average. Is there a function I can use to achieve this instead?
  • Pivot tables are cleaner and work better for what I am trying to do, but don't let you turn Total off per column when it isn't appropriate, like in the percentage table above. Is there a way around this in pivot tables, or do I need to use a straight table?
1 Solution

Accepted Solutions
sunny_talwar

Check this out and see if this help

Percentage Subtotal

View solution in original post

7 Replies
sunny_talwar

Check this out and see if this help

Percentage Subtotal

luismadriz
Specialist
Specialist

Nice solution, that's definitely thinking out of the box!

sunny_talwar

I am glad you like it

Anonymous
Not applicable
Author

Thank you. I have not had time to fully explore this option, I'll come back with my results.

pradosh_thakur
Master II
Master II

i have seen sunny doing it quite a few time in the community and i once applied it when all put their hands up and the team has  an illusion now that  i am the person who thinks out of the box. So passing the credit to you stalwar1‌.

Learning never stops.
sunny_talwar

Well I was not the one who started this (not sure who did), but I learnt this technique from kush141087‌... so passing along the credit to him

sudhir0538
Creator
Creator

Hi Sunny , It's really a great Stuff !

Can you help in my case. Details are mentioned in attached Excel format where sheet 1 is my input data and my sheet 2 are my expected output with Avg file.

Pls help to achieve this.