topic Set Analysis For Month in QlikView

Set Analysis For Month

kevbrown — Tue, 21 Jun 2016 09:43:37 GMT

Hi,

Easy question but I've had a mental block. I'm looking to find out the current number of employees I have and I don't want that to change no matter what selections on date is made. The field I have are CalMonth, CalYear, CalDay, Person ID and Leaving Date. So Leaving date must be null and I need to count distinct Person ID

Thanks

Kev

Re: Set Analysis For Month

MK_QSL — Tue, 21 Jun 2016 09:49:13 GMT

=COUNT(

CalMonth=, CalYear=, CalDay=, [Leaving Date] =,

[Person ID] = {"=Len(Trim([Leaving Date]))=0"}

Distinct [Person ID])

Re: Set Analysis For Month

kevbrown — Wed, 22 Jun 2016 08:07:51 GMT

That worked, thanks, however I've had a rethink.

I think what I need to know is how many current employees there are at a certain date. So Leaving date must be null or greater than the date selected in the calendar and Starting date must be less than the date selected

Re: Set Analysis For Month

MK_QSL — Wed, 22 Jun 2016 08:10:05 GMT

If you have another question, would be better if you raise another thread with example or sample data.