topic Re: Row by Row results when using Aggr in QlikView

Row by Row results when using Aggr

ashwath26_95 — Sat, 16 Nov 2024 04:19:49 GMT

Hi,

Please find the attached image.

I have used max(Aggr(Sum(Sales),region,segment)) to get the total Sales by each region per segment. But the problem is i am getting the value only for one record and not for all. You can check it in the image.

My requirement is that the total for each region,segment should be displayed for each row.

Re: Row by Row results when using Aggr

anushree1 — Wed, 27 Feb 2019 06:25:22 GMT

Could you share the sample data

Re: Row by Row results when using Aggr

ashwath26_95 — Wed, 27 Feb 2019 06:43:52 GMT

Source data ...

Re: Row by Row results when using Aggr

anushree1 — Wed, 27 Feb 2019 07:16:05 GMT

Is this the output you are looking for?

Re: Row by Row results when using Aggr

marcus_sommer — Wed, 27 Feb 2019 07:35:22 GMT

Per default aggr returned a distinct valuelist but you could add a NODISTINCT like:

max(Aggr(NODISTINCT Sum(Sales),region,segment))

- Marcus