topic Re: AGGR Function in QlikView

AGGR Function

Frédéricdh — Tue, 23 May 2023 09:18:17 GMT

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.

Re: AGGR Function

tresB — Tue, 23 May 2023 10:10:20 GMT

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

Re: AGGR Function

Frédéricdh — Tue, 23 May 2023 11:22:24 GMT

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.