Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total aggregation of dimension

Hello Guys,

I have a problem with total aggregation in dimension.Please check the attached and let help me to find the solution.

I want the total of Nb. Cust at.

Thanks

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Example attached.

View solution in original post

22 Replies
Not applicable
Author

Maybe removing the year from the aggregation?

swuehl
MVP
MVP

Not sure if I understand, you want which column to be aggregated as Total?

As far as I see, Nb. Cust is a dimension, you usually don't aggregate dimension values, but expression values.

Not applicable
Author

Thanks for replying,

I want to see the total of the   aggregation (dimension )  it means total of (Nb.cust) as a partial total.

Is there any way to achive it.

Thanks

Anonymous
Not applicable
Author

I dont know if i understand you correct, but if you move the calculated dimension to the left, and just add a partial sum, will that solve your problem?

Not applicable
Author

Thanks Marcus,

We want to see a number for each row and the total( or the partial total) at the end.

If you have any idea, I appreciate.

Thanks,

Nima

swuehl
MVP
MVP

If you use something like sum(NB_CUST) as expression, you get your totals, but I assume that is not what you want, you want only one expression evaluation per line, not per Year?

Not applicable
Author

So, as stefan said is not a dimension but an expression.

Move it to the expression tab and I believe you dont need to do the aggregation.

Anonymous
Not applicable
Author

Nima,

are u asking wath i post there some time ago?

Look my post

http://community.qlik.com/thread/46757

Not applicable
Author

Not exactly what you did, because I don't want to repeat it for every year.

Thanks