topic Set Analysis Help in QlikView

Set Analysis Help

Tue, 30 Apr 2013 12:13:02 GMT

I am looking to find the number of employees that were terminated in the last 60 days.

SamAccountName is the employee itentifier

Term_Date is the date of termination

This is what I put together so far but I keep getting a result of 0....

=Count(DISTINCT{$<TERM_DATE={'>$(=today()-60)'}>}SamAccountName)

Any Ideas?

swuehl — Tue, 30 Apr 2013 12:17:22 GMT

If your termination date format is e.g. 'MM/DD/YYYY', try

=count( DISTINCT {$<TERM_DATE = {">$(=Date(today()-60,'MM/DD/YYYY))"} >} SamAccountName)

Tue, 30 Apr 2013 12:18:37 GMT

Thank you! That did the trick, I need to remember formatting!

Thanks Again

Tue, 30 Apr 2013 12:20:58 GMT

=Count(DISTINCT{$<TERM_DATE={'>$(=Date(today()-60))'}>}SamAccountName)