Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Frédéricdh
Creator
Creator

AGGR Function

I try to run this Formel = Aggr(SUM({<ORT={'X'}} BLEGW)) in a Diagramm but it doesn't work.

The Sum works but the function Aggr doesn't. Why?

 

I want to aggregate the variable.

Labels (1)
2 Replies
tresesco
MVP
MVP

Sum() itself is an aggregation function. It aggregates as per your chart dimensions, or in-entirety if you are using it in an object without dimension. Aggr() is required when you want to aggregate values differently, i.e. - in a chart not according to the dimension, but by something else. Also, in aggr() you have to mention explicitly those dimensions/fields that you need to aggregate by. I suggest to read about it in qlik help Aggr | Qlik Help

Frédéricdh
Creator
Creator
Author

I read the help, I didn't understand.

And I already try to insert the dimension but it doesn't change something.

 

Can we launch a zoom-meeting in order not to speak in the dust and i will show you my problem.