AND OPERATION in SET ANALYSIS

satishkurra — Thu, 03 May 2018 12:51:35 GMT

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)

Re: AND OPERATION in SET ANALYSIS

satishkurra — Thu, 03 May 2018 15:02:58 GMT

Any one?

topic Re: AND OPERATION in SET ANALYSIS in QlikView

AND OPERATION in SET ANALYSIS

Re: AND OPERATION in SET ANALYSIS