Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Negative values with a condition

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.

15 Replies
Not applicable
Author

HERE IT IS! sorry i was kinda lost, i was able to use the FALSE thing but couldnt make the negative thing work

zebhashmi
Specialist
Specialist

I would say

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

sunny_talwar

Check this out

Capture.PNG

Not applicable
Author

Thank you! this works!

sunny_talwar

Awesome