Set Analysis Help

Tue, 15 Jan 2013 11:27:32 GMT

I am to campare a field with two variable in set analysis but while camparing a field wrt two fields , i can not able to convert the below expression in set analysis.

So please help me out..

((count(DISTINCT if(Emp_LeavingDate>= Quarter_Start and

Emp_LeavingDate<= Quarter_End and EMPLSTATUS = 0 and PAYSCALETY <> 'AP'

and PAYSCALETY <> 'TT'and PAYSCALETY <> 'T0',EMPLOYEE_Code)))

(((count(DISTINCT if(Emp_JoinningDate<= Quarter_Start and EMPLSTATUS = 3 and

PAYSCALETY <> 'AP'and PAYSCALETY <> 'TT'and PAYSCALETY <> 'T0',EMPLOYEE_Code))) +

(count(DISTINCT if(Emp_JoinningDate<= Quarter_End and EMPLSTATUS = 3 and

PAYSCALETY <> 'AP'and PAYSCALETY <> 'TT'and PAYSCALETY <> 'T0',EMPLOYEE_Code))))/2))

Re: Set Analysis Help

fosuzuki — Tue, 15 Jan 2013 21:27:43 GMT

The first count() should be translated to something like this:

count({<Emp_LeavingDate={">=$(Quarter_Start)<=$(Quarter_End)"}, EMPLSTATUS={0}, PAYSCALETY-={'AP','TT','T0'}>} DISTINCT EMPLOYEE_Code)

I guess it will not work at the first attempt... You'll have to check the format of the field Emp_LeavingDate and adjust the dollar-sign expansion of Quarter_Start and Quarter_End in a proper format.

The other count()'s are pretty similar, so if you get the first one you'll be able to adjust them.

topic Set Analysis Help in QlikView

Set Analysis Help

Re: Set Analysis Help