Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Arjunarao
Honored Contributor 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
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.

13 Replies
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

krishna_2644
Valued Contributor III

Re: Average in place of total in pivot table

Hi Wizard,

Check in the presentation tab.

Capture1.PNG

Arjunarao
Honored Contributor II

Re: Average in place of total in pivot table

Hi,

I am using PIVOT table, need Average.

krishna_2644
Valued Contributor 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
Arjunarao
Honored Contributor II

Re: Average in place of total in pivot table

Not working.

Capture.JPG

krishna_2644
Valued Contributor III

Re: Average in place of total in pivot table

No Sure if you need this.

See attached.

Not applicable

Re: Average in place of total in pivot table

Hi Qlikviewwizard,

try thisUntitled.png

Arjunarao
Honored Contributor II

Re: Average in place of total in pivot table

Any solution please.

krishna_2644
Valued Contributor 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))))