topic Re: Filter in Set Analysis in AGGR function in Integration, Extension & APIs

Filter in Set Analysis in AGGR function

Nasibe — Mon, 24 Oct 2022 07:58:15 GMT

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

Re: Filter in Set Analysis in AGGR function

Mark_Little — Mon, 24 Oct 2022 08:07:58 GMT

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.

Re: Filter in Set Analysis in AGGR function

Nasibe — Mon, 24 Oct 2022 08:24:16 GMT

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

Re: Filter in Set Analysis in AGGR function

edwin — Wed, 02 Nov 2022 13:10:57 GMT

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