topic Re: Aggr function for duplicate records in dimension in QlikView

Aggr function for duplicate records in dimension

Wed, 03 Jun 2015 05:04:51 GMT

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

Wed, 03 Jun 2015 05:43:42 GMT

Hi,

You can use NODISTINCT in your expressions like,

aggr(NODISTINCT sum(Sales),Outlet)

Hope it will help you.

Regards,

Sindhu Kannan.

Anonymous — Wed, 03 Jun 2015 05:45:17 GMT

Hi Navdeep

Check the attached QVW

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

Regards

Harsha

Wed, 03 Jun 2015 05:55:39 GMT

Thanks guys 🙂

Anonymous — Wed, 03 Jun 2015 06:00:00 GMT

Your Welcome....

Regards

Harsha

Wed, 03 Jun 2015 06:11:59 GMT

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 — Wed, 03 Jun 2015 06:46:32 GMT

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