topic Re: Negative values not showing on a bar chart in QlikView

Negative values not showing on a bar chart

Thu, 13 Mar 2014 16:55:02 GMT

See attached. Negative bars simply do not plot. I did force the Static Min in the Axes tab to -50 to show this.

Is this a bug?

Re: Negative values not showing on a bar chart

Thu, 13 Mar 2014 16:57:43 GMT

Can you post a sample?

or can you check the format?

I can see from the screenshot that negative numbers are left aligned - this shows that they are recognized as text and not numbers - would explain why they are not showing up in the bar chart.

Re: Negative values not showing on a bar chart

MK_QSL — Thu, 13 Mar 2014 17:06:55 GMT

Looks like formatting problem in your profit calculation.

Can you post your sample apps or file?

Re: Negative values not showing on a bar chart

Thu, 13 Mar 2014 17:07:11 GMT

If the load script itself is loading negative numbers in brackets like (10) instead of -10. It will be recognised as text only.

Re: Negative values not showing on a bar chart

Thu, 13 Mar 2014 17:41:12 GMT

Good catch - that was it! I changed the ($3.00) to -3.00 and it's working. I also added 'as Value' to the load script.

Thanks to all who posted.

Brooks

Re: Negative values not showing on a bar chart

MK_QSL — Thu, 13 Mar 2014 17:47:02 GMT

Please close the thread by selecting correct or helpful answer.