Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

satishkurra
Valued Contributor II

AND OPERATION in SET ANALYSIS

Hi

I'm trying to get AND OPERATION for below expression.

Right now it is performing OR operation of these 2 conditions where Won or Pipeline met but i need both Won and Pipeline to meet the condition

Can someone please help

Sum(

{<

Won=

{"<$(=(

Max(Aggr(Sum({<FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}Won),RecordID))

+

Min(Aggr(Sum({<FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}Won),RecordID)))

/2)"},FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=

,

Pipeline=

{"<$(=(

Max(aggr(Sum({<FiscalYear={'$(vMaxYear)'},Fiscal_Month_Number={'$(=Max({<FiscalYear = {'$(vMaxYear)'}>}Fiscal_Month_Number))'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}Pipeline),RecordID))

+

Min(aggr(Sum({<FiscalYear={'$(vMaxYear)'},Fiscal_Month_Number={'$(=Max({<FiscalYear = {'$(vMaxYear)'}>}Fiscal_Month_Number))'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}Pipeline),RecordID)))

/2)"},FiscalYear={'$(vMaxYear)'},Fiscal_Month_Number={'$(=Max({<FiscalYear = {'$(vMaxYear)'}>}Fiscal_Month_Number))'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=

>}

Pipeline)

1 Solution

Accepted Solutions
satishkurra
Valued Contributor II

Re: AND OPERATION in SET ANALYSIS

1 Reply
satishkurra
Valued Contributor II

Re: AND OPERATION in SET ANALYSIS