Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Negative values not showing on a bar chart

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?

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Negative values not showing on a bar chart

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

View solution in original post

5 Replies
Not applicable

Re: Negative values not showing on a bar chart

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.

MVP
MVP

Re: Negative values not showing on a bar chart

Looks like formatting problem in your profit calculation.

Can you post your sample apps or file?

Not applicable

Re: Negative values not showing on a bar chart

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

View solution in original post

Not applicable

Re: Negative values not showing on a bar chart

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

MVP
MVP

Re: Negative values not showing on a bar chart

Please close the thread by selecting correct or helpful answer.