Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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