Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
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
Hi Miguel,
Thanks for your reply.........
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
Hi Sean,
Thanks for your reply..