set analysis with dates

[karolina_]

Hi All

I cannot make set analysis work with fields - StartMonth and EndMonth as in attachement.

I tried it with as StartMonth, date( StartMonth,'YYYY-MM-DD'), $(=date( StartMonth,'YYYY-MM-DD')) nothing works

[srishsum2017]

Hi, Please use single quotes at the place of double quotes

[vardhancse]

Hi Change the expression to

=count({<[Hire date]={"$(='>=' & StartMotnh & '<=' & EndMonth)"}>}DISTINCT ID)

[tresB]

Try like:

Count(DISTINCT if([Hire date]>=StartMotnh and [Hire date]<=EndMonth, ID))

[antoniotiman · Accepted solution]

Hi Karolina,

You can't use Set Analysis.

Set Analysis is evaluated per Chart, not per Rows.

So, use like this

Count(DISTINCT If([Hire date] >= StartMotnh and [Hire date] <= EndMonth, ID))

Regards,

Antonio