topic Complex set analysis in QlikView

Complex set analysis

dseelam — Mon, 01 Aug 2016 15:18:59 GMT

Can any one explain set analysis behind this variable

$(vReqShipQtyToMonthEnd)

sum({$<ReqShipDateNum_OO={">$(=vCurrentDateNum) <$(=vMonthEndNum)"}, %ShipDate=, %ShipDateMonth=,

%ShipDateYear=, %ShipDateDay=, %CancelDate=, %CancelDateDay=, %CancelDateMonth=, %CancelDateYear=,

OrderDate_OO=, OrderDateDay_OO=, OrderDateMonth_OO=, OrderDateYear_OO= >} Quantity_OO)

Specially why they are using all this fled names in above calculations

%ShipDate=, %ShipDateMonth=,%ShipDateYear=, %ShipDateDay=, %CancelDate=, %CancelDateDay=,%CancelDateMonth=,%CancelDateYear=,

OrderDate_OO=, OrderDateDay_OO=, OrderDateMonth_OO=, OrderDateYear_OO=

Re: Complex set analysis

trdandamudi — Mon, 01 Aug 2016 15:23:10 GMT

It is doing SUM on Quantity_OO

Where ReqShipDateNum_OO is >=vCurrentDateNum AND < vMonthEndNum

They are using all other fields to ignore the selections of those respective fields if any,

Re: Complex set analysis

sunny_talwar — Mon, 01 Aug 2016 15:23:38 GMT

This seems to be Summing Quantity_OO between the dates vCurrentDateNum and vMonthEndNum. The rest of the calendar fields are ignored so that the expression is not filtered based on selection in any of those fields. So in short this expression will be only based on a range of ReqShipDateNum_OO