Aggr function for duplicate records in dimension

[#1]

Hi,

I have two dimensions, Store and Promoter and I have multiple promoters at same store,thus when  I am using aggr() to get the sum

of outlet sales, it's giving me null() for duplicates. Please check the attached app for more clarification.

Regards,

Navdeep

[#2]

Hi,

You can use NODISTINCT in your expressions like,

aggr(NODISTINCT sum(Sales),Outlet)

Hope it will help you.

Regards,

Sindhu Kannan.

[Anonymous · Accepted solution]

Hi Navdeep

Check the attached QVW

used aggr(NODISTINCT sum(Sales),Outlet) insted of aggr(sum(Sales),Outlet)

Regards

Harsha

[#4]

Thanks guys 🙂

[Anonymous]

Your Welcome....

Regards

Harsha

[#6]

Harsha I need a clarification,

In your expression "aggr(NODISTINCT sum(Sales),Outlet) insted of aggr(sum(Sales),Outlet)

DISTINCT ---> consider only unique records  such as Sum(DISTINCT orderid)

Where as NODISTINCT what does it mean???

am little bit confuse on this.

[Anonymous]

Hi Babi,

Basically Aggr function is nothing but a group by function

now we are using NODISTINCT because we want to repete the values more than once

for example you can try Just group by on some sample data and just say Aggr with out Distinct as by defult it  consider as Distinct only

hope this Helps

Regards

Harsha