Negative values with a condition

[#1]

Hi,

I am trying to show a graph of sales where i have returned things in negative.

I also have a contion that allows me to show if the sale is on a especific program:

Sum({$<Duplica={"0"}>}[SumOfTEVSEQ01])

I would need to show the negative values in the graph but i dont know how.

Thank you.

[sunny_talwar]

Is your expression not showing negative values? Can you share a sample to take a look at?

[#3]

The graph do not totalize correctly. cause it should be 208.820... 7 are returned items so they are negative -7

It sais

[#4]

Try with this

and this formula:

Sum({$<Duplica={"0"}>}[SumOfTEVSEQ01])

it does not sum the negatives.

[sunny_talwar]

What is Duplica here?

[#6]

Duplica is the mark for the program so if its false I should  sum it  and if its true I should not take it into consideration.

[sunny_talwar]

Does Duplica include 0 and 1 or False and True? This seems to be working for me

Sum({$<Duplica={'FALSE'}>} SumOfTEVSEQ01)

[#8]

I tried this but the graph becomes empty

[sunny_talwar]

Can you share your app?

[#10]

sorry I dont know how to do that! i am new in qlik  😕