topic Re: negative values over bar in QlikView

negative values over bar

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Could you suggest how to display both the positive and negative values over bars in the bar chart? In my screenshot the values for the negative values are below the bars..

Thanks a lot

Tommy

Re: negative values over bar

Tue, 10 Jan 2017 13:45:09 GMT

Or one more question - if I would like to plot the values inside the bars - is there a chance to display them also if the bar is very narrow? Currently it displays for me the values only if tha bar is wide enough for the numbers.

Thanks

Tommy

Re: negative values over bar

girirajsinh — Tue, 10 Jan 2017 13:46:55 GMT

what would be your Y-axis in that case when you show bar with negative in upper part ?

if you are looking to convert your -negative measure to positive, then you may try function sign() which tells you if its positive or negative and then you can change it conditionally.

Re: negative values over bar

jonathandienst — Tue, 10 Jan 2017 13:48:05 GMT

You could take the Fabs() value for the bars, and adjust the bar offsets (using Sgn()) so that the negative bars are correctly positioned. That would place the values above the bars. You might need to use a Combo chart and add the actual values (not absolutes) in a separate expression and use that expression with the text on bars option.

Re: negative values over bar

jonathandienst — Tue, 10 Jan 2017 13:48:51 GMT

>>Or one more question - if I would like to plot the values inside the bars - is there a chance to display them also if the bar is very narrow?

I dont think so.

Re: negative values over bar

girirajsinh — Tue, 10 Jan 2017 13:49:25 GMT

for putting values inside you can do it by changing these two properties