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
Did you mean:
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.

 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
Contributor III
Author

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

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.

Community Browser