Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashis
Creator III
Creator III

How to show negative values in bar chart

Hi,

We have a bar chart and my requirement is i need to show all the values(positive and negative) in Y axis and on the same direction.

So i used these code in the expression to get the chart 

=fabs(sum ({$<dim={'abc'}>}xxx)) - converting negative values with absolute values. Please see the screen shot attached, and distinguishing negative values with red color and positive value with green color.

Now i need to show the '-' sign if the value is negative however the chart bar should be on the y axis same direction as it is .

so my requirement is to display the '-' if it is negative. Is there way to do it.

10 Replies
ashis
Creator III
Creator III
Author

Thank you Vegar, for your time. You also gave me one qvw file earlier that was working fine.

I believe something weird happening  at my end. I am unable to send my application due to some restriction of data.

I will look into it why it is causing the issue. The solution seems simple though.

 

Thank you very much.