Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey!
I'm new in qlikview and my english is not really good - so, first of all: sorry!
My problem is the following:
I have different departments with different number of employees.
Now i want to have in the column "Total" the average of all month and not the total number.
I'm using a Pivot table in qlikview!
Department | Jan | Feb | Mar | Apr | May | Total |
---|---|---|---|---|---|---|
A | 5 | 2 | 3 | 8 | 3 | 21 |
B | 2 | 1 | 4 | 2 | 3 | 12 |
C | 3 | 1 | 8 | 1 | 1 | 14 |
Total | 10 | 4 | 15 | 11 | 7 | 47 |
Does anybody know what to do?
Thanks and best regards!
You can use the dimensionality() function in an if statement to calculate a different expression for the detail cells and the total cells. See attached example.
You can use the dimensionality() function in an if statement to calculate a different expression for the detail cells and the total cells. See attached example.
Hi!
I use an if statement in the expression; "dimensionality()=0" for the "vertical" total, "ColumnNo()=0" for "horizontal" totals.
example:
if(ColumnNo()<>0, MyExpression, TotalExpr)
Hi G Wassenaar,
Your attachement is 92342 not 92318. I don't see the Dimensionality() function.
i think you drag the month column in pivot if yes then
in total column write this
sum(field)/sum(total field)in number tab fixed to 2 and check on show in %
hi
firstly for find the average--
write syntax-
sum(fieldname)/sum(total fieldname)
***************************************
in presentation tab
select field and check show partial sum.