topic Re: AGG Function with set analysis in QlikView

AGG Function with set analysis

RCGreco2304 — Fri, 28 Jan 2022 17:42:22 GMT

Guys,

I need to aggregate the information by the highlighted fields, but I would like the value to be repeated for each of the lines of the aggregation

Note that in the last column I have the aggregated values correctly but it only appears for a single row of the aggregated dimensions

hic — Sat, 29 Jan 2022 16:30:00 GMT

You need to have all relevant dimensions listed in your Aggr() function. For example, year, month and sales batch are missing.

Now you have a grain mismatch between your chart and your Aggr() call.

HIC

RCGreco2304 — Mon, 31 Jan 2022 09:42:24 GMT

Henric,

Thanks for your answer!

But the Sales Batch field is one field that I don't want to agregate, and the Year and Month were agrgegated by the Id_Date. Right?

tresB — Mon, 31 Jan 2022 10:22:42 GMT

If I understood correct, try putting NODISTINCT in aggr(), like:

Sum( (Aggr(Nodistinct Sum(...

RCGreco2304 — Mon, 31 Jan 2022 10:42:52 GMT

Perfect. That's it. Thanks a lot