Expression output not coming

tripatirao — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

=SUM(AGGR((IF(SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[ILE_Qtr_Temp.Invoiced Sale Weight]) > SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight]),0,

(IF(FABS((SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight])- SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[ILE_Qtr_Temp.Invoiced Sale Weight]))) < FABS(SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight])*0.1),0,

SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight])-SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[ILE_Qtr_Temp.Invoiced Sale Weight]))))),[PCS_Line.PCS No_],PCS_Line.EntityIdentifier,PCS_Line.Region,PCS_Line.DeliveryDate,PCS_FiscalYear,PCS_month))

The above expression is not working for me

the value for MonthStart(max(PCS_Line.DeliveryDate)) is 1st Dec 2016 and Monthend(max(PCS_Line.DeliveryDate)),2) is 28th Dec 2017

But my expression value is showing for only 1st Dec 2016. it is not showing for the range.

Please let me know what might be the reason.

Regards

Tripati

Re: Expression output not coming

sunny_talwar — Thu, 08 Dec 2016 12:59:15 GMT

Have you selected a particular date? May be try this:

=SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}

AGGR((IF(SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[ILE_Qtr_Temp.Invoiced Sale Weight]) > SUM({<PCS_Line.DeliveryDate ={">=$(=MonthStart(max(PCS_Line.DeliveryDate)))<=$(=MonthEnd(max(PCS_Line.DeliveryDate),2))"},PCS_FiscalYear=,PCS_month=>}[PCS_Line.Sale Weight]),0,

topic Expression output not coming in QlikView

Expression output not coming

Re: Expression output not coming