set analysis syntax help

[veeranj]

HI Group,

I need the syntax in writing set analysis expresion.

i have columns like emp_disengaged_date,reason,id

i want to count the no of employees whose date is greater than today and with employees with reason c (whose date<todays date)

thanks,

Anjee

[#2]

It will be better if you may share qvd with your data model and sample data.

regards

Darek

[MK_QSL]

COUNT({<reason = {'c'}, emp_disengaged_date = {'>$(=Date(Today()))'} >}employees)

or

COUNT({<reason = {'c'}, emp_disengaged_date = {'>$(=Date(Today()))'} >}Distinct employees)

[veeranj]

HI Manish,

Here the reason =c and emp_disengaged_date = {'>$(=Date(Today())) are and conditions ?

[rajat2392]

yes..this will work as AND condition..if both are true, then the count is made.

[#6]

COUNT({<reason = {'c'}, emp_disengaged_date = {'>$(=Date(Today()))'} >}id)

it will count the number of  id's,

based on the conditions Reason = 'c' and date > today