topic Set Analysis Help in QlikView

Set Analysis Help

Sat, 05 Jan 2013 06:33:44 GMT

I have to change this expression into set analysis.

=count(DISTINCT if((EMPLGROUP <> 9 and (EMPLSTATUS = '0' and PAYRL_AREA = '90'))

(FinYear = vMaxFinYear and Year_Month_new = vMaxMonthName and EMPLGROUP <> 9 and (EMPLSTATUS = '3' and (PAYRL_AREA = '68' or PAYRL_AREA = '72' or PAYRL_AREA = '74'
or PAYRL_AREA = '77' or PAYRL_AREA = '97' or PAYRL_AREA = '99')))

, EMPLOYEE_Code)

Re: Set Analysis Help

phaneendra_kunc — Sat, 05 Jan 2013 06:54:04 GMT

Try this...

count({<(EMPLGROUP-={9}>*(<EMPLSTATUS = {0}> * <PAYRL_AREA ={90}>))

(<FinYear = {'$(vMaxFinYear)'}> * < Year_Month_new = {'$(vMaxMonthName)'}> * <EMPLGROUP-={9}>* (<EMPLSTATUS = {3}>*<PAYRL_AREA ={'72','74','77','97','99'}> ) ) }

Disitnct EMPLOYEE_Code))

+ --- is OR

* --- is AND

above expression is not verified. test with your model...