topic Problem adds negative values in App Development

Problem adds negative values

Anonymous — Fri, 06 Apr 2018 11:41:35 GMT

Hi, I'm new to Qlik. I have the following problem. I have a table with movements, some movements are positive and others negative. I need a totalizer for which I have a simple expression. sum (cantUM1). The problem is that I do not subtract the movements in negative. That is, is not taking the negative sign, how should I fix it?

Re: Problem adds negative values

m_woolf — Fri, 06 Apr 2018 16:29:27 GMT

what you are doing should work.Can you show a sample of your data?

Re: Problem adds negative values

Anonymous — Fri, 06 Apr 2018 19:09:25 GMT

his is a table in SQL, in this example they entered 411 units and came out 68.79. On my board solves me 411 + 68.79 + 231 + 2 +1, etc

Re: Problem adds negative values

veidlburkhard — Sat, 07 Apr 2018 12:03:46 GMT

Hi Frederico,

not sure I understand your problem, but if you want to ignore the negative values, you can use this expression:

sum (fabs(cantUM1)).

Fabs just gives you the absolute value!

Regards

Burkhard

Re: Problem adds negative values

Anonymous — Mon, 09 Apr 2018 11:39:14 GMT

My problem is that you are not subtracting the negative values. I add all the values, I need to subtract the negative ones. What expression should I use? Thank you!!

Re: Problem adds negative values

veidlburkhard — Mon, 09 Apr 2018 18:24:48 GMT

Hi Frederico,

this is exactly what the expression sum (fabs(cantUM1)) does. It adds the positive ones and subtracts the negative ones.

Why don't you try?

Regards

Burkhard