How to supress the Negative values in BarChart

[Anonymous]

Hi Qlickers,

I'm facing a problem in Barchart,

I want to supress the negative values of a bar chart. Is it Possible in QlikSense Bar chart ????

Thanks in Advance..

[Miguel_Angel_Baeyens]

Hi,

You can create a new measure for example

If(Sum(Sales) > 0, Sum(Sales))

And store it in the Master Items library. If Sum(Sales) for the given dimension is less than zero, then it will not be represented.

Miguel

[Anonymous]

Hi Miguel,

Thanks for your reply.........

[Anonymous · Accepted solution]

Hi Venkata,

Here is another method to suppress negative values in Qlik Sense.  In edit mode, select the bar chart and go to the dimension properties on the right side of the Desktop.  From there, on the limitation drop down, select "exact value" and set it to be greater than or equal to 0.  This will suppress all values on the bar chart that have a negative value.

Cheers,

Sean

[Anonymous]

Hi Sean,

Thanks for your reply..