Multiple IF conditions then Sum Quantity

Anonymous — Thu, 22 Mar 2018 06:51:05 GMT

I might be confused in QlikSense expression.

I am calculating sum(Quantity) according to whichever date is detected first but there will always have value in Req Ship Date. After getting each type of date total, I will display by YearMonth. Let's say Req Shipment = 60pcs in the month of April, ETD Port = 20pcs in the month of April, DO = 0pcs in April, so total for April is 80pcs.

Example

if DO Completion Date NOT NULL

vDO+=quantity

elseif DO Completion Date is Null

if ETD POL Date NOT NULL

vETD+=quantity

elseif ETD POL Date is Null

vReq+=quantity

-------------------------------------------------

Total April is vDO+vETD+vReq

How do I produce this in chart fx ?

if([DO Completion Date] <> '',vDO = vDO + [Quantity (PCS)], if([DO Completion Date] = '', if([ETD Port Of Loading Date] <> '', vETD = vETD + [Quantity (PCS)], if([ETD Port Of Loading Date] = '', vREQ = vREQ + [Quantity (PCS)])), vDO+vETD+vREQ))

topic Multiple IF conditions then Sum Quantity in QlikView

Multiple IF conditions then Sum Quantity