Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

Average in place of total in pivot table

Hi All,

How to get the Average in place of total in pivot table.

Thanks in advance.

Required output:

Capture.JPG

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Average in place of total in pivot table

Hi,

And in Presentation tab Change caption to Average in Labels for Totals text box for both Country and JOB dimension.  PFA for solution.

Regards,

Jagan.

View solution in original post

13 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Average in place of total in pivot table

Within the tab presentation in the top left you could set a total-name for each dimension.

- Marcus

Highlighted
Specialist III
Specialist III

Re: Average in place of total in pivot table

Hi Wizard,

Check in the presentation tab.

Capture1.PNG

Highlighted
Master II
Master II

Re: Average in place of total in pivot table

Hi,

I am using PIVOT table, need Average.

Highlighted
Specialist III
Specialist III

Re: Average in place of total in pivot table

I guess by using dimensionality() function  we can achieve this

I guess something like this:

if(dimensionality()=1,RangeMax(0,avg(Slaes)))

but i did not get a chance to implement.

try this and let me know.

Highlighted
Master II
Master II

Re: Average in place of total in pivot table

Not working.

Capture.JPG

Highlighted
Specialist III
Specialist III

Re: Average in place of total in pivot table

No Sure if you need this.

See attached.

Highlighted
Not applicable

Re: Average in place of total in pivot table

Hi Qlikviewwizard,

try thisUntitled.png

Highlighted
Master II
Master II

Re: Average in place of total in pivot table

Any solution please.

Highlighted
Specialist III
Specialist III

Re: Average in place of total in pivot table

I have attached the solution yesterday itself. check out

Capture1.PNG

edit:

use the expression :

If(Dimensionality()=2,

       round(Sum(Sales)),

              round(avg(aggr(sum(Sales),Country,JOB))))