Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Solution

Accepted Solutions
Not applicable
Author

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
Author

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.

MK_QSL
MVP
MVP

Looks like formatting problem in your profit calculation.

Can you post your sample apps or file?

Not applicable
Author

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

Not applicable
Author

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

MK_QSL
MVP
MVP

Please close the thread by selecting correct or helpful answer.