Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Frédéricdh
Creator II
Creator II

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 II
Creator II
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.