topic Re: Distinct Sum Aggregation issues in QlikView

Distinct Sum Aggregation issues

vivek1864 — Wed, 13 Sep 2023 23:18:59 GMT

Hello Everyone,

I'm new to Qlik and have been facing issues with aggr distinct sum. When I use below function to calculate the selling price, I get different number to the actual selling price. Its really strange and difficult to figure out what possibly could be wrong.

selling price = sum(aggr(sum(distinct selling price),competitor, material))

Competitor	Material	Actual Selling Price	Selling Price
A	1	1995	1953
B	1	1995	1953
C	1	1995	1953
A	2	234	230
B	2	234	230
C	2	234	230

Re: Distinct Sum Aggregation issues

rwunderlich — Wed, 13 Sep 2023 23:37:00 GMT

Why the Aggr()? Why not Sum(SellingPrice) or Avg(SellingPrice)?

-Rob

Re: Distinct Sum Aggregation issues

vivek1864 — Wed, 13 Sep 2023 23:39:04 GMT

I only need to see distinct values when calculating the totals. Sum will give me dups and avg will take avg of entire sales which I don't want

Re: Distinct Sum Aggregation issues

rwunderlich — Thu, 14 Sep 2023 18:26:10 GMT

You have multiple occurrences of selling price? You seem to be taking care of that with Sum(Distinct...

I'm not understanding your data. Can you post some sample data?

-Rob