Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Group by in Set analysis

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

Labels (2)
1 Solution

Accepted Solutions
santhiqlik
Creator
Creator

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. 

View solution in original post

3 Replies
santhiqlik
Creator
Creator

Hi,
Please try this..

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

No use, Thank you.
santhiqlik
Creator
Creator

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.