topic Re: Positive and Negative values in QlikView

Positive and Negative values

Fri, 18 Mar 2016 17:29:35 GMT

See attached, How do i fabs the negative data and negate the positive data?

Re: Positive and Negative values

swuehl — Fri, 18 Mar 2016 17:31:04 GMT

Not sure I understand, are you looking for

=Sum(-Data)

Re: Positive and Negative values

sunny_talwar — Fri, 18 Mar 2016 17:31:46 GMT

May be multiply by -1

Sum(Data) * -1

Re: Positive and Negative values

Fri, 18 Mar 2016 17:36:00 GMT

No, See the table. I wanna change negative values to positive and change positive to negative

Re: Positive and Negative values

Fri, 18 Mar 2016 17:36:56 GMT

No Sunny, I wanna change positive values to negative why negative to positive

Re: Positive and Negative values

sunny_talwar — Fri, 18 Mar 2016 17:38:05 GMT

That's what this is doing. When the sum is positive, it will make it negative and when it is negative, it will make is positive

Re: Positive and Negative values

martinpohl — Fri, 18 Mar 2016 17:40:30 GMT

I don't what the problem is with sum(-Data)

It will change positive values to negative and negatives to positive

Re: Positive and Negative values

Fri, 18 Mar 2016 17:51:34 GMT

See attached:

I have a field called Data. It has both Negative and Positive values. I want to make the positive values negative why the Negative values positive. Clear?

Re: Positive and Negative values

swuehl — Fri, 18 Mar 2016 17:54:35 GMT

So it's about grouping the data, then reversing the sign?

=Sum( Aggr(-Sum(Data), no))

edit: No, it's not clear what you are asking for without knowing your requested result (AKA what you expect to see).

Re: Positive and Negative values

Fri, 18 Mar 2016 18:15:08 GMT

I want to do this at the backend not on the chart

Re: Positive and Negative values

Fri, 18 Mar 2016 18:26:46 GMT

I have a field pulled from the database, having both -/+ values. How do i change these values at the backend sure that the negative becomes positive and the positive values become negative?

Re: Positive and Negative values

sunny_talwar — Fri, 18 Mar 2016 18:28:13 GMT

For backend, you can do like this:

LOAD FieldName * -1 as FieldName

...

Re: Positive and Negative values

swuehl — Fri, 18 Mar 2016 18:36:05 GMT

Sorry, still missing something here.

You want to do what exactly at the backend? Could you please elaborate your requirements, like describing what your exact expected result is using your sample data you posted above.

Seems like no is just a record number, so

=Sum( Aggr(-Sum(Data), no))

should equal

=Sum(-Data)

and if you want to do it at the backend, just use what Sunny provided, though I am not sure what you really want here.

Have a nice evening,

Stefan