topic Re: match command how to add 2nd condition ? in QlikView

match command how to add 2nd condition ?

paulyeo11 — Sun, 06 Jul 2014 00:11:12 GMT

Hi All

I have created the expression below which match 1 CONDITION IF COUNTRY = SG ( WORKING FINE ):-

if(match(Currency_P,'SG'),

money(

(AFTER_DISCOUNT*RATE_EU*TRANS_SUP/MU_TDS),

CurrencyFormat_P)

)

Now I need to add one more condition :-

BRAND_P=GE

I try :-

if(match(Currency_P,'SG') and (BRAND_P,'GE'),

money(

(AFTER_DISCOUNT*RATE_EU*TRANS_SUP/MU_TDS),

CurrencyFormat_P)

)

it does not work , hope some one can help me.

Paul

Re: match command how to add 2nd condition ?

paulyeo11 — Sun, 06 Jul 2014 00:12:07 GMT

QV doc

Re: match command how to add 2nd condition ?

maxgro — Sun, 06 Jul 2014 00:36:08 GMT

maybe you have to add another match (bold)

if(match(Currency_P,'SG') and match(BRAND_P,'GE'),

..................

Re: Re: match command how to add 2nd condition ?

paulyeo11 — Sun, 06 Jul 2014 01:34:00 GMT

Hi Massimo

Thank you very much it work fine now .

Now i hv following up question :-

I have 2 script , 1st one is :-

if(match(Currency_P,'SG') and (match (BRAND_P,'GE')),

(AFTER_DISCOUNT*RATE_US*TRANS_SUP/MU_TDS)

)

and 2nd one is :-

if(match(Currency_P,'SG') and (match (BRAND_P,'IBH')),

(AFTER_DISCOUNT*RATE_EU*TRANS_SUP/MU_TDS)

)

I want to combine both into 1 script :-

if(match(Currency_P,'SG') and (match (BRAND_P,'GE')),

(AFTER_DISCOUNT*RATE_US*TRANS_SUP/MU_TDS)

)

if(match(Currency_P,'SG') and (match (BRAND_P,'IBH')),

(AFTER_DISCOUNT*RATE_EU*TRANS_SUP/MU_TDS)

)

Re: Re: match command how to add 2nd condition ?

paulyeo11 — Sun, 06 Jul 2014 01:37:28 GMT

Hi Massimo

I found the answer by trail and error , and it work :-

(

match(Currency_P,'SG') and (match (BRAND_P,'IBH')

(AFTER_DISCOUNT*RATE_EU*TRANS_SUP/MU_TDS),

if(match(Currency_P,'SG') and (match (BRAND_P,'GE')),

(AFTER_DISCOUNT*RATE_US*TRANS_SUP/MU_TDS)

)