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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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 (2)
2 Replies
tresB
Champion III
Champion III

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.