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:
I would need to show the negative values in the graph but i dont know how.
Is your expression not showing negative values? Can you share a sample to take a look at?
The graph do not totalize correctly. cause it should be 208.820... 7 are returned items so they are negative -7
Try with this
and this formula:
it does not sum the negatives.
What is Duplica here?
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.
Does Duplica include 0 and 1 or False and True? This seems to be working for me
I tried this but the graph becomes empty
Can you share your app?
sorry I dont know how to do that! i am new in qlik :/
Uploading a Sample
HERE IT IS! sorry i was kinda lost, i was able to use the FALSE thing but couldnt make the negative thing work
Check this out
I would say
Thank you! this works!
Retrieving data ...