Discussion Board for collaboration related to QlikView App Development.
Hi All,
How to get the Average in place of total in pivot table.
Thanks in advance.
Required output:
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.
Within the tab presentation in the top left you could set a total-name for each dimension.
- Marcus
Hi Wizard,
Check in the presentation tab.
Hi,
I am using PIVOT table, need Average.
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.
Not working.
No Sure if you need this.
See attached.
Hi Qlikviewwizard,
try this
Any solution please.
I have attached the solution yesterday itself. check out
edit:
use the expression :
If(Dimensionality()=2,
round(Sum(Sales)),
round(avg(aggr(sum(Sales),Country,JOB))))