Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

venkatasreekant
Valued Contributor

How to supress the Negative values in BarChart

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..

1 Solution

Accepted Solutions
sod
Contributor

Re: How to supress the Negative values in BarChart

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

4 Replies
MVP
MVP

Re: How to supress the Negative values in BarChart

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

venkatasreekant
Valued Contributor

Re: How to supress the Negative values in BarChart

Hi Miguel,

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

sod
Contributor

Re: How to supress the Negative values in BarChart

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

venkatasreekant
Valued Contributor

Re: How to supress the Negative values in BarChart

Hi Sean,

Thanks for your reply..