topic Re: How to make this Expression in SET Analysis in QlikView

How to make this Expression in SET Analysis

sona_sa — Sat, 07 Aug 2021 05:30:13 GMT

Hi Friends,

How to make this expression in QlikView or Qlik Sense.

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

Thanks

Re: How to make this Expression in SET Analysis

rajpreeths — Sat, 07 Aug 2021 06:27:31 GMT

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

Re: How to make this Expression in SET Analysis

sona_sa — Sat, 07 Aug 2021 06:37:37 GMT

Hi Raj,

Thanks for reply, But this expression is not working.

Please suggest.

Thanks

Re: How to make this Expression in SET Analysis

rajpreeths — Sun, 08 Aug 2021 18:18:53 GMT

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.

Re: How to make this Expression in SET Analysis

Chanty4u — Mon, 09 Aug 2021 03:47:44 GMT

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

Re: How to make this Expression in SET Analysis

sona_sa — Mon, 09 Aug 2021 08:45:16 GMT

Please find the attached xls for the same

THANKS.

Re: How to make this Expression in SET Analysis

sona_sa — Mon, 09 Aug 2021 08:52:50 GMT

Please find the attached xls for the same

THANKS.