Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Help

I have to change this expression into set analysis.

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

or

(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)

1 Reply
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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...