Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
dseelam
Creator II
Creator II

Complex set analysis

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=

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
trdandamudi
Master II
Master II

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,

sunny_talwar

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