How to make this Expression in SET Analysis

[sona_sa]

Hi Friends,

How to make this expression in QlikView or Qlik Sense.

=Count(DISTINCT If(MonthEnd(Link_Date)=Monthend(DOJ),[EmpCode]))

Thanks

[rajpreeths]

May be like this.

COUNT({<Link_Date={"=InMonth(Link_Date,DOJ,0)"}>}distinct EmpCode)

Please ensure Link_date and DOJ are in same format before using this expression. If needed have same format in the backend

[sona_sa]

Hi Raj,

Thanks for reply, But this expression is not working.

Please suggest.

Thanks

[rajpreeths]

I tried in my local.its working for me.if it's not working for you, please verify date formats of linkdate and doj. Also share some sample data and the output you look for.

[Chanty4u]

can you share any sample data with the columns which you are using in the expression.

[sona_sa]

Please find the attached xls for the same

THANKS.

[sona_sa]

Please find the attached xls for the same

THANKS.