topic AND condition in Set Analysis in QlikView

AND condition in Set Analysis

Anonymous — Tue, 25 Apr 2017 07:36:26 GMT

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

Re: AND condition in Set Analysis

Anonymous — Tue, 25 Apr 2017 07:41:06 GMT

You use E() Function in you set analysis.

Re: AND condition in Set Analysis

Anil_Babu_Samineni — Tue, 25 Apr 2017 07:41:33 GMT

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)

Re: AND condition in Set Analysis

tresB — Tue, 25 Apr 2017 07:42:21 GMT

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)