Set Analysis

Mon, 19 Oct 2015 07:09:27 GMT

Hi Everyone,

I have EmployeeCode,GradeCode and Cal_Date fields,I want to find out employees Count who has same grade from last 3 years

Any suggestions would be greatly appreciated.

Regards,
P.Divya

Re: Set Analysis

tresB — Mon, 19 Oct 2015 07:15:39 GMT

Something like:

Count({<EmployeeCode ={"=Count({<Cal_Date ={'>=$(=Date(AddYears(Max(Cal_Date ), -3))) <=$(=date(Max(Date)))'}>}Distinct GradeCode)=1 "}, Cal_Date ={'>=$(=Date(AddYears(Max(Cal_Date ), -3))) <=$(=date(Max(Date)))'}>}Distinct EmployeeCode)

Update: Include the same time set restriction in the inner count as well. Corrected few glitches as well.

topic Set Analysis in QlikView

Set Analysis

Re: Set Analysis