topic Re: loading negative nrs into a field is not working in QlikView

loading negative nrs into a field is not working

alec1982 — Fri, 21 Sep 2012 20:34:38 GMT

hi guys,

I have a filed in the database that contain possitive and negative nrs as follow:

USP

(50)

(20)

(3)

the negative values on the database have () to recognize them but it seems that Qv is not recognizing them as Negative values.

Anyway I can fix that and make the qvw recognize the negative nrs.

Thxs,

Alec

MayilVahanan — Fri, 21 Sep 2012 20:45:44 GMT

Try like this,

=if(FindOneOf(UPS,'()'), PurgeChar(UPS,'()')*-1),UPS)

Hope it helps

swuehl — Fri, 21 Sep 2012 20:47:13 GMT

You probably need to tell QV how to interprete the negative format:

num#('(50)','#;(#)')

should read the '(50)' in as negative number. So try

LOAD

num#(USP,'#;(#)') as USP

FROM Table;

Regards,

Stefan

alec1982 — Mon, 24 Sep 2012 14:51:10 GMT

Hi Stefan,

Using this method I am getting wrong nrs and when I do Sum(USP) I get 0 which should not be.

Thxs,

swuehl — Mon, 24 Sep 2012 14:57:43 GMT

Hi Alec,

seems to work for me, please check attached.

Stefan

alec1982 — Mon, 24 Sep 2012 16:06:17 GMT

hi,

thank you for your help.

it works in your example but not sure why it is not working on mine.

The solution provided by Mayil is working as required.

Thxs,