
Re: How to get negative data point values to show on top for a bar chart?
Sree Nivas Aug 22, 2012 1:20 AM (in response to nicole00)Can u send the sample data

Re: How to get negative data point values to show on top for a bar chart?
nicole00 Aug 22, 2012 8:43 AM (in response to Sree Nivas)Here

test.qvw 136.2 K

Re: How to get negative data point values to show on top for a bar chart?
Stefan Wühl Aug 22, 2012 9:22 AM (in response to nicole00)You could try something like
=dual(Value,if(Value<0,0.000001,Value))
as expression.

test_negValues.qvw 138.2 K


Re: How to get negative data point values to show on top for a bar chart?
nicole00 Aug 22, 2012 10:19 AM (in response to nicole00)Thanks for your response. But my real data set has negative decimal numbers. The scale is based on percentages actually. But, I was not able to load the decimal values in the load statement. The values showed up as text. I didn't think it would make a difference.
How do you format the VALUE field to recognize the value as numbers if they are decimals?
I can attach another sample when I figure that out???????

Re: How to get negative data point values to show on top for a bar chart?
nicole00 Aug 22, 2012 10:26 AM (in response to nicole00)Here is a copy of the sample with the load * inline script that shows the decimal values.
Help please!!!!!!

test_negValues[2].qvw 137.2 K

Re: How to get negative data point values to show on top for a bar chart?
Stefan Wühl Aug 22, 2012 10:57 AM (in response to nicole00)nicole00,
I've attached best I could get.
Regards,
Stefan

test_negValues_2.qvw 141.5 K

Re: How to get negative data point values to show on top for a bar chart?
nicole00 Aug 22, 2012 11:30 AM (in response to Stefan Wühl )Thanks for trying! Your solution shows commas, which will not work. Also my real data set reflects a maximum of 100% (or 1) and minimum of any negative percentage. For example max 100% (or 1.0) and a min 3,247% (or 32.47).
Qlikview seems to be so complicated!!!!!

Re: How to get negative data point values to show on top for a bar chart?
Stefan Wühl Aug 22, 2012 11:41 AM (in response to nicole00)Yes, formatting could be a lot simpler, I agree.
My previous solution showed comma as decimal separator, because that's what was specified in your original sample file.
I changed that in attached file and added a huge negative value.

test_negValues_3.qvw 141.5 K

Re: How to get negative data point values to show on top for a bar chart?
nicole00 Aug 22, 2012 12:16 PM (in response to Stefan Wühl )If I had a comma in my original data set then it shouldn't be, it was a typo.
The only time a comma should show up is in the presentation when showing 3,247%.
I tried using your example (top right), but the negative values just show 0.0%. My real data set is not based on a load inline script.
The Value is based on an expression = ((sum([Balance])/sum([Ceiling Amt]))
So I inserted my expression everywhere it says Value and I get 0.0%?????

Re: How to get negative data point values to show on top for a bar chart?
nicole00 Aug 22, 2012 12:46 PM (in response to nicole00)BTW, I get 0.0% just for the negative numbers.
What is that last part of the expression supposed to do 0.000010?
I don't understand why I am not able to get to work?


Re: How to get negative data point values to show on top for a bar chart?
nicole00 Aug 22, 2012 1:13 PM (in response to Stefan Wühl )I figured out why I was getting 0.0% instead of a negative value %. I had the number formatted, so I changed it to expression default.
I have added the hidden field but now my sort order is all wrong?

Re: How to get negative data point values to show on top for a bar chart?
nicole00 Aug 22, 2012 2:19 PM (in response to Stefan Wühl )I think this would be a great solution if there was a way to sort all the values (see example)?
The sample I provided worked out because the dates increased with the value amounts.
Unfortunately, my real data set is not going to work out that way. Any help would be greatly appreciated.

test_negValues[3].qvw 140.2 K

Re: How to get negative data point values to show on top for a bar chart?
Stefan Wühl Aug 22, 2012 3:57 PM (in response to nicole00)Just try a sort by expression in sort tab using
=Value

Re: How to get negative data point values to show on top for a bar chart?
nicole00 Aug 22, 2012 4:21 PM (in response to Stefan Wühl )No luck, I have already tried that.

Re: How to get negative data point values to show on top for a bar chart?
Stefan Wühl Aug 22, 2012 4:32 PM (in response to nicole00)Seems to work at my side, see attached. I am using QV11.
It should also be possible to sort by yvalue, using this as hidden expression:
=num(Value,'#0.0%')
and set static min for axis scale to 0

test_negValues4.qvw 143.8 K

Re: How to get negative data point values to show on top for a bar chart?
nicole00 Aug 22, 2012 4:45 PM (in response to Stefan Wühl )Awesome thank you!










