Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
CB308
Contributor III
Contributor III

summing negative values in separate column

Hello

How can I realize this logic/formula?

If I have a total of two separate columns and the value is negative (see Position-stock), how do I show only the negative values in a separate column and able to total all negatives?  Currently my total is zero instead of  5493405.

Thank you in advance!!!!

Totals

Ending Position

Stock

Position-Stock

Negative Totals as Positive

Totals

25453598

23003823

2449775

0

PLine1

19591501

20736596

-1145095

1145095

Pline2

8995999

13344309

-4348310

4348310

11 Replies
CB308
Contributor III
Contributor III
Author

that did help... i'll let you know the results and thank you for your time.  It is appreciated.

CB308
Contributor III
Contributor III
Author

thank you for all the answers, still having an issue, but using the same data, how would I calculate lets use "Ending Postion" percent to total of the "Ending Position" column?

Currently my calculation for Ending Position is column(1) + column(3), + column(5) onwards.

=num(sum(("Ending Position") ) / sum (Total ("Ending Position") is obviously not correct, need help please.