Replacing if else with pick match

kishorj1982 — Mon, 24 Sep 2018 06:20:36 GMT

Hi All,

Could you please assist me how to replace below code with pick match.

CONCATENATE ([Order Delivery Days])

LOAD *,

Dual (If ([Delivery Difference Days] > 0,

If ([Delivery Difference Days] <= 5, 'Week or Less',

If ([Delivery Difference Days] <= 10, 'Two Weeks or Less',

If ([Delivery Difference Days] <= 20, 'Month or Less',

If ([Delivery Difference Days] <= 40, 'Two Months or Less', 'Over Two Months'))))),

If ([Delivery Difference Days] > 0,

If ([Delivery Difference Days] <= 5, 1,

If ([Delivery Difference Days] <= 10, 2,

If ([Delivery Difference Days] <= 20, 3,

If ([Delivery Difference Days] <= 40, 4, 5)))))) as [Late Status];

CONCATENATE ([Order Delivery Days])

and

If ([Order Delivery Status by Calculated GI Date] = 'On Time', [Order Delivery Status by Calculated GI Date],

If (Floor ([Planned Delivery Date]) <= Floor ([Sales Document Creation Date]), '1. Bad First Date',

If ([%Plant_PLANT] = 'US09', '2. US09 Plant - Springfield',

If (Floor ([Planned Delivery Date]) = Floor ([Sales Document Creation Date] + 1), '3. ATP Error',

If (Match ([%Item category_ITEM_CATEG], 'ZTAG', 'ZTSG', 'ZTAC', 'ZTAK', 'ZTBG', 'ZTL1', 'ZTL4', 'ZTLK', 'ZTRO', 'ZLBX') AND Floor ([Production Order Delivery Date]) > Floor ([Planned Delivery Date]), '4. Manufacture to Order',

If (Floor ([Actual Goods Issue Date]) >= Floor ([Planned Delivery Date]) AND Floor ([Delivery Document Creation Date]) <= Floor ([Planned Delivery Date]), '5. Warehouse Issue',

If (Match ([%Item category_ITEM_CATEG], 'ZTAP', 'ZTAB') > 0 AND Floor ([Latest Purchase Order Goods Received Date]) > Floor ([Planned Delivery Date]), '6. Vendor',

If (Match ([%Item category_ITEM_CATEG], 'ZTAS', 'ZUCS', 'ZTCS', 'ZTBS', 'ZLKF', 'ZSAS', 'ZSST'), '7. Drop Shipment',

If (Match ([%Item category_ITEM_CATEG], 'ZTNN', 'ZANN'), '8. Stock Items',

If ([Domestic/Export] = 'Export', '9. Export Order', '10. Other')))))))))) as [Late Analysis]

topic Replacing if else with pick match in QlikView

Replacing if else with pick match