topic Re: IF & MATCH in QlikView

IF & MATCH

upaliwije — Thu, 29 Sep 2016 10:55:43 GMT

Hi,

I have following lines in my data load script

if(TXN_TYPE=1,REF_NO) AS DEBIT_NOTE_NO,

if(TXN_TYPE=2,REF_NO) AS SETT_REC_NO,

if(TXN_TYPE=4,REF_NO) AS REFUND_SLIP_NO,

if(NOT MATCH(TXN_TYPE,1,2,4,REF_NO)) AS OTHERS,

But the last line does not work . What I want is if TXN_TYPE<>1,2,4 the REF_NO should be others

Pls help me to correct abobe error

sunny_talwar — Thu, 29 Sep 2016 10:56:49 GMT

May be try this:

If(not Match(TXN_TYPE,1,2,4),REF_NO) AS OTHERS,

jonathandienst — Thu, 29 Sep 2016 10:58:17 GMT

Is this what you are after?

if(MATCH(TXN_TYPE,1,2,4) = 0, REF_NO) AS OTHERS,

vinieme12 — Thu, 29 Sep 2016 10:58:37 GMT

Try with quotes

if(MATCH(TXN_TYPE,'1','2','4')=0,REF_NO)) AS OTHERS,

Anonymous — Thu, 29 Sep 2016 11:05:28 GMT

may be this?

if(TXN_TYPE<>1 or TXN_TYPE<>2 or TXN_TYPE<>4 ,REF_NO) AS Others