Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New field generated based on other fields data

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

1 Solution

Accepted Solutions
Not applicable
Author

NewData:

Load Client_name,

         invoice_number,

        Value,

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

        Outstading_amoun

From Table;

View solution in original post

3 Replies
MayilVahanan

HI

PFA

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

NewData:

Load Client_name,

         invoice_number,

        Value,

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

        Outstading_amoun

From Table;

Not applicable
Author

Thank you