topic Re: script : add a field based on a condition (if ??) in QlikView

script : add a field based on a condition (if ??)

Wed, 18 Apr 2012 14:56:42 GMT

hello

i have a table like this :

account mnt

600000; 300.00

601001; 308.00

606004; 12000.00

700011; 82000.00

780559 ; 12.00

I would like to add a field in my table based :

-field account everything that begins with 6xxxxx (a field expense)

-field account everything that begins with 7xxxxx (a field product)

to arrive at this

account ; mnt ; expense/product

600000; 300.00 ; expense

601001; 308.00 ; expense

606004; 12000.00 ; expense

700011; 82000.00 ; product

780559 ; 12.00 ; product

thanks for your help

jagannalla — Wed, 18 Apr 2012 15:22:54 GMT

Hello,

Use the below code.

Load

account,

mnt,

If(Left(account,1)='6','Expense',If(Left(account,1)='7','Product')) as ExpenseOrProduct

From Table;

Hope it helps you..

Wed, 18 Apr 2012 15:30:49 GMT

thank you for your help