Solved: Re: loading negative nrs into a field is not worki... - Qlik Community

alec1982 · ‎2012-09-21

hi guys,

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

USP

(50)

(20)

(3)

5

8

10

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 · ‎2012-09-21

Hi

Try like this,

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

Hope it helps

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

MayilVahanan · ‎2012-09-21

Hi

Try like this,

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

Hope it helps

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

swuehl · ‎2012-09-21

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 · ‎2012-09-24

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 · ‎2012-09-24

Hi Alec,

seems to work for me, please check attached.

Stefan

alec1982 · ‎2012-09-24

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,

loading negative nrs into a field is not working