topic Re: value require from two column in QlikView

value require from two column

yadav_anil782 — Mon, 08 Jun 2015 08:35:37 GMT

Dear All,

i have vendore wise two amount column- 1st is "invoice_amount" and 2nd is currency_conerted_amount

now i wants to generate one new column with this expression -( i want "currency_conerted_amount " againsed vendor and if it is null then value should be put from " invoice_ amount)

plz help to generate this new column

Re: value require from two column

qlikmsg4u — Mon, 08 Jun 2015 08:46:56 GMT

try like this

Load if(len(trim(currency_conerted_amount))=0,invoice_ amount,currency_conerted_amount ) as newColumn

Re: value require from two column

ToniKautto — Mon, 08 Jun 2015 08:48:39 GMT

For questions like this it would be great to know if you are looking for a script solution or a chart object solution.

A simple sample document with a few lines of data will also make it a lot easier for someone to provide a suggestion that fits your purpose.

Re: value require from two column

Peter_Cammaert — Mon, 08 Jun 2015 08:51:26 GMT

"currency_conerted_amount" or "currency_converted_amount"?

Try this (assuming you want this new column created in your load script):

IF (IsNull(currency_conerted_amount), invoice_amount, currency_conerted_amount) AS third_amount,

Alt(currency_conerted_amount, invoice_amount) AS third_amount,

This will handle only NULL values (as per your specification), not zero or blank amounts...

Best,

Peter

Re: value require from two column

jonathandienst — Mon, 08 Jun 2015 09:24:54 GMT

Alt() will handle blank amounts as well as NULL.

ISNULL() will only work with NULL,

Re: value require from two column

Peter_Cammaert — Mon, 08 Jun 2015 10:09:54 GMT

Sorry, yes you're right, Jonathan. Alt() will handle everything that doesn't look like a number. Even text strings...

Thanks, Peter