Filter in Set Analysis in AGGR function

[Nasibe]

Hi Qlikview Experts,

in Formula below When I filter on Vendor or others they don't work.Could you help me?

Count(
DISTINCT Aggr(

if(Count({<Vendor=,Brand=,ProductGroup=,ProductSubGroup=,ProductName=,Product_Code=>} DISTINCT OrderNumber)=0
,Customer_Code),Customer_Code
))


Thanks

[Mark_Little]

You need to make sure you carry your set expression up the AGGR function.

Because you are only apply the set Expression on the original set analysis the vendor selection isn't being ignored in your top count.

[Nasibe]

Thanks for your quick reply
this you mean:

Count({<Vendor=,Brand=,ProductGroup=,ProductSubGroup=,ProductName=,Product_Code=>}
DISTINCT Aggr(

if(Count({<Vendor=,Brand=,ProductGroup=,ProductSubGroup=,ProductName=,Product_Code=>} DISTINCT OrderNumber)=0
,Customer_Code),Customer_Code
))

it returns Zero value.
could please write correct formula?
Thanks in advance

[edwin]

do you have sample data you can post so we can see whats happening?