Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
philmywallet
Contributor

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
Highlighted
laddu_927
Valued Contributor

Re: AND condition in Set Analysis

You use E() Function in you set analysis.

Highlighted

Re: AND condition in Set Analysis

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
MVP
MVP

Re: AND condition in Set Analysis

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)