Qlik Community

Qlik Sense App Development

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

msmcilvride
New Contributor II

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

Re: Show Total and Average in pivot table or straight table

Check this out and see if this help

Percentage Subtotal

6 Replies

Re: Show Total and Average in pivot table or straight table

Check this out and see if this help

Percentage Subtotal

luismadriz
Valued Contributor

Re: Show Total and Average in pivot table or straight table

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

Re: Show Total and Average in pivot table or straight table

I am glad you like it

msmcilvride
New Contributor II

Re: Show Total and Average in pivot table or straight table

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

pradosh_thakur
Valued Contributor III

Re: Show Total and Average in pivot table or straight table

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‌.

Re: Show Total and Average in pivot table or straight table

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

Community Browser