topic Re: Negative to positive number conversion in QlikView

Negative to positive number conversion

Anonymous — Mon, 29 Dec 2014 03:05:47 GMT

I have the following expression

Num([Drug Code],'000000') as [Drug Code]

How can the above expression be adapted to change negative numbers into positive numbers in cases where these negative numbers exist in addition to formatting a number into a six digit one when required?

Regards

Chris

Re: Negative to positive number conversion

preminqlik — Mon, 29 Dec 2014 03:26:14 GMT

try this

Num(fabs([Drug Code]),'000000') as [Drug Code]

Re: Negative to positive number conversion

jagan — Mon, 29 Dec 2014 03:48:24 GMT

Hi,

Use Fabs() to convert negative to positive.

Fabs(Num([Drug Code],'000000')) as [Drug Code]

Regards,

Jagan.

Re: Negative to positive number conversion

Anonymous — Mon, 29 Dec 2014 03:53:49 GMT

Prem, many thanks, i will try it out and revert

Regards

Chris

Re: Negative to positive number conversion

Anonymous — Mon, 29 Dec 2014 03:54:25 GMT

Jagan, many thanks, i will try it out and advise accordingly

Regards.

Chris