Create new dimension with multi condition in the Script

ericheleine — Thu, 22 Feb 2018 16:24:37 GMT

Good Morniing every one,

I need some help to find the better way to achieve the script below:

I want to create a dimension called CoverName using the following test:

1 / If the PNG_TRADE_DIRECTION is BUY, and MIFIDName least one of the fields (1,2,3,4) | MIFIDPrice (1,2,3,4) is filled.

2 / If thePNG_TRADE_DIRECTION is SELL, and in less than a MIFIDName1,2,3,4 fields | MIFIDPrice1,2,3,4 is filled.

Script data:

Trade Direction : ["PNG_TRADE_DIRECTION"]

MIFIDName1 : ["PNG_TRADE_MIFID_NAME_1"]

MIFIDName2 : ["PNG_TRADE_MIFID_NAME_2"]

MIFIDName3 : ["PNG_TRADE_MIFID_NAME_3"]

MIFIDName4 : ["PNG_TRADE_MIFID_NAME_4"]

MIFIDName5 : ["PNG_TRADE_MIFID_NAME_5"]

MIFIDPrice1 : ["PNG_TRADE_MIFID_PRICE_1"]

MIFIDPrice2 : ["PNG_TRADE_MIFID_PRICE_2"]

MIFIDPrice3 : ["PNG_TRADE_MIFID_PRICE_3"]

MIFIDPrice4 : ["PNG_TRADE_MIFID_PRICE_4"]

MIFIDPrice5 : ["PNG_TRADE_MIFID_PRICE_5"]

topic Create new dimension with multi condition in the Script in QlikView