topic Re: If Condition in QlikView

If Condition

dseelam — Fri, 11 Aug 2017 20:13:17 GMT

Hello,

IF(CUSTNAME = 'AMAZON.COM', 'eCom Standard', ORDER_TYPE) ,

If(CUSTNAME = 'e Supply', 'eCom Standard', ORDER_TYPE) as ORDER_TYPE

Some how only e Supply is falling under eCom Standard, Amazon.com is falling under different order type

how to change the condition so that both customers fall under eCom standard?

Thanks

vishsaggi — Fri, 11 Aug 2017 20:28:39 GMT

Try this ?

IF(Match(CUSTNAME, 'AMAZON.COM', 'e Supply'), 'eCom Standard', ORDER_TYPE) as ORDER_TYPE

vishsaggi — Fri, 11 Aug 2017 20:30:24 GMT

Or Try like

IF(CUSTNAME = 'AMAZON.COM', 'eCom Standard',

If(CUSTNAME = 'e Supply', 'eCom Standard', ORDER_TYPE)) as ORDER_TYPE