Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

AND condition in Set Analysis

Hi

I have a set analysis which works fine.

As per below :

(count({<

Leavers.Leaving_Reason-={'Flexi Retirement'},

Dates.FiscalYear={'15/16'}

>} Leavers.Leaving_Reason))

I now need to exclude any Fixed Term Contract staff but only exclude 'Medical & Dental' staff from the fixed term contract leaving reason.  I tried the below, but it doesn't work.

(count({<

Leavers.Leaving_Reason-={'Flexi Retirement'},

Leavers.Leaving_Reason-={'Fixed Term Contract'} and [Staff Group]={'Medical and Dental'},

Dates.FiscalYear={'15/16'}

>} Leavers.Leaving_Reason))

Any help appreciated.

Thanks

Phil

3 Replies
Anonymous
Not applicable
Author

You use E() Function in you set analysis.

Anil_Babu_Samineni

Like this?

count({<Leavers.Leaving_Reason-={'$(=Only([<Leavers.Leaving_Reason = {'Fixed Term Contract'}, [Staff Group]={'Medical and Dental'}>} Leavers.Leaving_Reason))'}, Dates.FiscalYear={'15/16'} >} Leavers.Leaving_Reason)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
tresesco
MVP
MVP

May be like:

count({

<Leavers.Leaving_Reason-={'Flexi Retirement'} , Dates.FiscalYear={'15/16'}> *

<Leavers.Leaving_Reason-={'Fixed Term Contract'} , [Staff Group]={'Medical and Dental'}>

} Leavers.Leaving_Reason)