Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Negative values with a condition

Check this out

Capture.PNG

15 Replies

Re: Negative values with a condition

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

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.

Re: Negative values with a condition

What is Duplica here?

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.

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

Not applicable

Re: Negative values with a condition

I tried this but the graph becomes empty pruebafales.JPG

Re: Negative values with a condition

Can you share your app?

Not applicable

Re: Negative values with a condition

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

Community Browser