Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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

Highlighted
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  😕