Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
cristianj23a
Partner - Creator III
Partner - Creator III

Obtain negative values in expression

Hi.

I'm trying to get the negative difference of two calculations but I can not with the Aggr.

- The column displays 2 rows that have negative values.

Captura.PNG

- What I want to get is the sum of those two negative rows in the other table that only have one dimension

Captura.PNG

But as it is displayed in the image it shows me the total.

Captura.PNG

I can not find the logic to just add the negative values.

In this case you should leave -8162.11.

Please, help me with this problem, I already have time and the desired result does not appear.

Very thankful.

Greetings.

I attach the qvw.

https://www.linkedin.com/in/cristianjorge/
Do not forget to mark as "Accepted Solution" the comment that resolves the doubt.
3 Replies
Frank_Hartmann
Master II
Master II

Please remove section access!

cristianj23a
Partner - Creator III
Partner - Creator III
Author

Hi Frank.

Update the qvw.

https://www.linkedin.com/in/cristianjorge/
Do not forget to mark as "Accepted Solution" the comment that resolves the doubt.
Frank_Hartmann
Master II
Master II

see here:

Obtain negative values in expression

hope this helps