topic postive and negative values in QlikView

postive and negative values

Wed, 08 Jul 2015 08:22:39 GMT

Hi im showing the postive and negative values for a particular column, I would like to reverse, which displaying, how can I do that

for eg: -97 should show 97

for eg: 100 should show as -100

im using qlikview 8.0 thanks

Re: postive and negative values

Anonymous — Wed, 08 Jul 2015 08:27:01 GMT

just use_ "-sum(val1)" or "-field1"

all values will be reverted!

you might Change it in script also "-val1 as newval1" and use the new field

Re: postive and negative values

alexandros17 — Wed, 08 Jul 2015 08:27:13 GMT

If your expression is something like

Sum(value)

then change it in

Sum(value) * -1

Let me know

Re: postive and negative values

pokassov — Wed, 08 Jul 2015 08:27:26 GMT

Hello

-eg

Re: postive and negative values

Wed, 08 Jul 2015 08:38:34 GMT

Hi Rahim,

We can use the following expression.

if(sign(fieldname)=-1,fabs(fieldname),-1*fieldname)

Re: postive and negative values

Michiel_QV_Fan — Wed, 08 Jul 2015 08:41:27 GMT

Rahim,

just multiply the end result of your expression with -1. Be sure to enclose the full expression in ( ) and make the * -1 as final calculation outside the ( ).