# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for
Search instead for
Did you mean: Not applicable

## aggregated value in pivot table total

Hello

I have an aggregated value on a higher lever dimension that should repeated on a lower level dimension, the total should not be the sum of the  repeated value but rather the value itself.

the exemple is described bellow in the column expression 1 in the attached file

Thanks in advance for your help

1 Solution

Accepted Solutions Not applicable
Author

Actually I have found the answer, if you ever meet this sort of requirement you need to adjust the expression using dimensionality Function in my case

if(Dimensionality()=1

or Dimensionality()=0,   sum([field]),    [field])

Thank you very much for your answers

6 Replies Not applicable
Author

Try using Distinct... Not applicable
Author

you mean  sum (distinct field)? Not applicable
Author

Sorry distinct will not help you, attached app may help u ..

if

(RowNo()>=1,sum(Expression1),sum(TOTAL Expression1))

or

if

(RowNo()>=1,sum(Expression1),sum(DISTINCT Expression1))  Employee

You can use a combination of

sum( TOTAL <Dim1,Dim2, <dim3>> value)

TOTAL = All records in table

<dim1> will return aggregate by dim1

<dim1,dim2> will return aggregate by dim1,dim2  Champion

Try

Aggr(distinct sum( TOTAL <Dim1,Dim2, <dim3>> value))

Vikas Not applicable
Author

Actually I have found the answer, if you ever meet this sort of requirement you need to adjust the expression using dimensionality Function in my case

if(Dimensionality()=1

or Dimensionality()=0,   sum([field]),    [field])

Thank you very much for your answers 