topic ISSUE using Class function and removing duplicate staff_ids in QlikView https://community.qlik.com/t5/QlikView/ISSUE-using-Class-function-and-removing-duplicate-staff-ids/m-p/969831#M332170 <HTML><HEAD></HEAD><BODY><P>Issue: I have created 2 reports which suppose to be same value but Those reports as below: one report tells how many of them are contract employees are there and How many are permanent employees there. the issue is when ever I am creating the report which is detail level year wise list of employees, it is giving wrong result. To resolve I have tried below ways: In Calculated Dimension I have taken as below: code written in caluclated Dimension: =Dual(Replace(class(vMaxYr-Year(DOB),5),'$(vMaxYYYYMM)'}, [(h)Staff Employment Type ID] =&nbsp; , //[(h)Sort Key] = {"=aggr(max({1}[(h)Sort Key]), [(h)Staff ID])"}, STF_DEMOGRPHCS_FLAG={'Y'}&nbsp;&nbsp; //[(h)Sort Key]={'count(Aggr(MAX([(h)Sort Key]),[(h)Staff ID]))'} &gt;} DISTINCT [(h)Staff ID]) Cn you please guid me how to reach my requirment that is instead of 72 i am getting value 99&nbsp; for contract employees. </P></BODY></HTML> Tue, 24 Nov 2015 07:31:16 GMT 2015-11-24T07:31:16Z ISSUE using Class function and removing duplicate staff_ids https://community.qlik.com/t5/QlikView/ISSUE-using-Class-function-and-removing-duplicate-staff-ids/m-p/969831#M332170 <HTML><HEAD></HEAD><BODY><P>Issue: I have created 2 reports which suppose to be same value but Those reports as below: one report tells how many of them are contract employees are there and How many are permanent employees there. the issue is when ever I am creating the report which is detail level year wise list of employees, it is giving wrong result. To resolve I have tried below ways: In Calculated Dimension I have taken as below: code written in caluclated Dimension: =Dual(Replace(class(vMaxYr-Year(DOB),5),'$(vMaxYYYYMM)'}, [(h)Staff Employment Type ID] =&nbsp; , //[(h)Sort Key] = {"=aggr(max({1}[(h)Sort Key]), [(h)Staff ID])"}, STF_DEMOGRPHCS_FLAG={'Y'}&nbsp;&nbsp; //[(h)Sort Key]={'count(Aggr(MAX([(h)Sort Key]),[(h)Staff ID]))'} &gt;} DISTINCT [(h)Staff ID]) Cn you please guid me how to reach my requirment that is instead of 72 i am getting value 99&nbsp; for contract employees. </P></BODY></HTML> Tue, 24 Nov 2015 07:31:16 GMT https://community.qlik.com/t5/QlikView/ISSUE-using-Class-function-and-removing-duplicate-staff-ids/m-p/969831#M332170 2015-11-24T07:31:16Z