topic Group by in Set analysis in QlikView

Group by in Set analysis

Anonymous — Sat, 16 Nov 2024 04:56:32 GMT

Hi All,

Need Salesman Count, when his sales is '0' in current and previous month.

Below expression not work, it showing count individual. Check the sample data.

Any leads appreciate.

Count(distinct{<[Win Count]={'$(=Aggr(Sum([Win Count]),link_Salesman)=0)'},
link_Date={">=$(vLast2MonthsStart)<=$(vCurrentDate)"},[Fiscal Year]=,[Fiscal Quarter]=,[Fiscal Month]=>} link_Salesman)

TIA

Re: Group by in Set analysis

santhiqlik — Tue, 18 Dec 2018 08:47:31 GMT

Hi,
Please try this..

Count(distinct{<[link_Salesman]=p({<[WinCount]={0},link_Date={">=$(vLast2MonthsStart) <=$(vCurrentDate)"}>} link_Salesman)>} link_Salesman)

Re: Group by in Set analysis

Anonymous — Tue, 18 Dec 2018 08:57:24 GMT

No use, Thank you.

Re: Group by in Set analysis

santhiqlik — Tue, 18 Dec 2018 09:21:28 GMT

Hi,

When I used the below expression using the sample data you have provided, I got 2 as the answer. Is this what you are looking for?

Count({<[Salesman Name]={"=Sum([Win Count])=0"}>} Distinct [Salesman Name])

I didn't add date filter since your data is already is filtered with current and previous month.