topic Re: If condition in load column in QlikView

If condition in load column

0li5a3a — Wed, 22 Jun 2016 22:47:48 GMT

Hi,

I want to make a new column in my table.

table:

load

order_no,

customer ref no,

date

from xyz.qvd

My customer ref no column contain information like :

1234568

abcdefg

321456

RMA:123456/0

RMA:abcdef/0

I want to make a column what will contain just these customer ref no's information:

1234568

abcdefg

321456

Can I use IF condition to do this?

if(customer ref no = RMA:, ignore and go to next customer ref)

Could someone help me with my problem please.

Best Regards,

Constantin

ankit777 — Thu, 23 Jun 2016 08:55:48 GMT

try this in where condition:

left([customer ref no],3) <> 'RMA'

ankit777 — Thu, 23 Jun 2016 08:57:34 GMT

if you want to do this for one column do this:

if(left([customer ref no],3) <> 'RMA',[customer ref no]) as column_name

0li5a3a — Thu, 23 Jun 2016 09:19:49 GMT

Thanks for your answer. Is really helpful!