Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
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
jagan
Partner
Partner

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
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

krishna_2644
Specialist III
Specialist III

Hi Wizard,

Check in the presentation tab.

Capture1.PNG

qlikviewwizard
Master II
Master II
Author

Hi,

I am using PIVOT table, need Average.

krishna_2644
Specialist III
Specialist III

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.

qlikviewwizard
Master II
Master II
Author

Not working.

Capture.JPG

krishna_2644
Specialist III
Specialist III

No Sure if you need this.

See attached.

Not applicable

Hi Qlikviewwizard,

try thisUntitled.png

qlikviewwizard
Master II
Master II
Author

Any solution please.

krishna_2644
Specialist III
Specialist III

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))))