Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.

1 Solution

Accepted Solutions
Highlighted

Re: Negative values with a condition

15 Replies
Highlighted

Re: Negative values with a condition

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

Highlighted
Not applicable

Re: Negative values with a condition

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

It sais mayo.JPG

Not applicable

Re: Negative values with a condition

Try with this

pruebacha.JPG

and this formula:

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

it does not sum the negatives.

Highlighted

Re: Negative values with a condition

What is Duplica here?

Highlighted
Not applicable

Re: Negative values with a condition

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.

Highlighted

Re: Negative values with a condition

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

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

Capture.PNG

Highlighted
Not applicable

Re: Negative values with a condition

I tried this but the graph becomes empty pruebafales.JPG

Highlighted

Re: Negative values with a condition

Can you share your app?

Highlighted
Not applicable

Re: Negative values with a condition

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