topic Re: to replicate data from one column to another with minus sign in QlikView

to replicate data from one column to another with minus sign

tahreen371 — Sat, 16 Nov 2024 21:44:39 GMT

Hello all,

I have one column as Amount and i need to replicate a new Column called Payment with every value in amount column is not positive

And all the values in Payment column should have Negative sign before it.

And refer 2nd example where the value for 2nd value in amount column is already negative but still it should show just negative

OmarBenSalem — Wed, 12 Dec 2018 09:21:32 GMT

- fabs(Column1) as column2

tresB — Wed, 12 Dec 2018 09:21:37 GMT

Fabs(Amount)*(-1) as Column

santhiqlik — Wed, 12 Dec 2018 09:32:04 GMT

Hi,

This can be achieved using sign() in script as follows

Load

Amount,

If(Sign(Amount)=1,Num('-' & Amount),Amount) as Payment // Sign() returns 1 for positive values

From Table;

Let me if this helps !!

--Priya

tahreen371 — Wed, 12 Dec 2018 09:32:40 GMT

Hello All,

I aslo tried with this script:

if(num(AMOUNT)>0,num(AMOUNT)*-1, AMOUNT_IN_LC_TEMP) as Payment

It worked and thank you for quick response