Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
satishkurra
Specialist II
Specialist 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
Specialist II
Specialist II
Author

1 Reply
satishkurra
Specialist II
Specialist II
Author

Any one?