topic count distinct by time period in QlikView

count distinct by time period

Fri, 18 Apr 2014 16:00:21 GMT

I have a very large file of demographic data, and I have fields such as TIME_PERIOD, which is each month, Jan, Feb, Mar. I have YEAR, TERM_DATE, as well as BEGIN_DATE and END_DATE, which give the beginning and ending dates for each month per employee's record. I am trying to count terminations per period, and I've tried several combinations of suggestions on this forum and none seem to give the correct answer. Can anyone provide a formula where in a chart I can calculate distinct terms per Month (TIME_PERIOD)?

Re: count distinct by time period

its_anandrjs — Fri, 18 Apr 2014 16:05:06 GMT

If you provide any sample data may be more easy.

Re: count distinct by time period

Fri, 18 Apr 2014 17:07:08 GMT

Well its really just rows of employee numbers, termination dates, hire dates, and nulls for non termed employees. Each employee number has a TIME PERIOD, a BEGIN_DATE, and an END_DATE. I saw some other forums give examples like Re: count if date >= AND <= than value but I only want to count distinct instances of TERM_DATE per TIME_PERIOD.