topic Re: New field generated based on other fields data in QlikView

New field generated based on other fields data

Tue, 19 Mar 2013 23:21:38 GMT

Hi,

I have data for a cashflow.

I have the client data with the value of the invoices and the value of the outstanding amount. I would like to genretate a new column that I would like to populate with two statements:

If the value is zero, I would like to populate with "Payed"

If the value is not zero I would like to populate with "Not payed"

Raw data:

Client_name, invoice_number, Value, Outstading_amount

xxx, 1234, 5500, 0

xxx, 1235, 2500, 2000

yyy, 3456, 8000, 5000

After imported I would like to have a table like this:

Client_name, invoice_number, Value, Outstading_amount, Status

xxx, 1234, 5500, 0 ,Payed

xxx, 1235, 2500, 2000 ,Not payed

yyy, 3456, 8000, 5000 ,Not payed

Thank you

Re: New field generated based on other fields data

MayilVahanan — Wed, 20 Mar 2013 00:13:09 GMT

PFA

Hope it helps

Re: New field generated based on other fields data

Wed, 20 Mar 2013 05:32:48 GMT

NewData:

Load Client_name,

invoice_number,

Value,

If(Value<>0, 'Not payed', 'Payed') as NewValue,

Outstading_amoun

From Table;

Re: New field generated based on other fields data

Wed, 20 Mar 2013 13:15:43 GMT

Thank you