Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to Solution.
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
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.
Looks like formatting problem in your profit calculation.
Can you post your sample apps or file?
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.
Please close the thread by selecting correct or helpful answer.