Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

JustinDallas
Valued Contributor II

Incorporate AND in Set Analysis after ORs

Hello Folks,

I've currently got this set analysis which reads:

A or B or C or D

What I would like to say is something like this

( A or B or C or D) AND ( Y = Foo ).



How do I express the phrase AND ( Y = Foo )?


This is the monstrosity I've got, essentially once we've satisfied the date requirements, I need to add an "AND EmploymentType='Contractor'".  I could put this into each and everyone one of my date OR filters, but that seems sloppy and will make my statement even less readable.

COUNT(

{<[Employee Start Date]={"<=$(=Min(GenDate))"}, mpp_terminationdt={">=$(=Min(GenDate)) <=$(=Max(GenDate))"}>+

        <[Employee Start Date]={">=$(=Min(GenDate))"},  mpp_terminationdt={"<=$(=Max(GenDate))"}>+

            <[Employee Start Date]={">=$(=Min(GenDate)) <=$(=Max(GenDate))"}, mpp_terminationdt={">=$(=Max(GenDate))"}>+

                <[Employee Start Date]={"<=$(=Min(GenDate))"}, mpp_terminationdt={">=$(=Max(GenDate))"}>}

                  mpp_id

Any help is greatly appreciated.

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Incorporate AND in Set Analysis after ORs

you could add an If statement as below:

Count( {< set analysis >} if( EmploymentType = 'Contractor', mpp_id ) )

OR

try adding in Set Analysis as below:

Count( { < set analysis > * < EmploymentType = {'Contractor'} >} mpp_id )

2 Replies
agigliotti
Honored Contributor II

Re: Incorporate AND in Set Analysis after ORs

you could add an If statement as below:

Count( {< set analysis >} if( EmploymentType = 'Contractor', mpp_id ) )

OR

try adding in Set Analysis as below:

Count( { < set analysis > * < EmploymentType = {'Contractor'} >} mpp_id )

JustinDallas
Valued Contributor II

Re: Incorporate AND in Set Analysis after ORs

Well, that was anti-climatic...

Community Browser