Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
msmcilvride
Contributor III
Contributor III

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

msmcilvride
Contributor III
Contributor III
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.