topic Bar Chart (upside down) in QlikView

Bar Chart (upside down)

Thu, 13 Nov 2014 16:26:17 GMT

Hi. I want to display a bar chart so the horizontal axis is on top and the bars proceed down from there. I have temporarily achieved something close to this by making my expressions negative.

But this leaves me with two problems.

1) The axis (and labels) are still on the bottom of the chart.

2) The numbers on the axis display as negative.

So I have two questions:

1) Is there a way to manipulate this to make the labels appear on top of the chart and make the values appear positive despite being negaitve?

2) Did I miss some more simple formatting that would enable me to do this without having to find a workaround?

Thanks so much for any help.

Re: Bar Chart (upside down)

MarcoWedel — Thu, 13 Nov 2014 21:43:16 GMT

Hi,

maybe this helps:

regards

Marco

Re: Bar Chart (upside down)

Thu, 13 Nov 2014 23:05:17 GMT

Thanks, Marco. That's pretty much what I'm going for. But how did you make that happen?

Re: Bar Chart (upside down)

jduenyas — Thu, 13 Nov 2014 23:16:10 GMT

Click in the chart and then Ctrl+Shift and observe all the red boxes.

Then go to the chart's properties and see in Presentation the values in Reference Lines and Text in Chart.

Also in the Axes tab see the Hide Axis check and the values for the Static Min and Static max.

That will start you going

Re: Re: Bar Chart (upside down)

MarcoWedel — Thu, 13 Nov 2014 23:18:40 GMT

Hi,

I used this expression

=Dual(Fact,-Fact)

to format negative expression values as positive numbers, hid the expression axis and added reference lines and texts in chart instead.

Maybe not the most dynamic solution, but hopefully can be of any use nevertheless.

Regards

Marco

Re: Bar Chart (upside down)

Thu, 13 Nov 2014 23:19:21 GMT

I wound up doing something very similar to this. Thank you.

Re: Bar Chart (upside down)

Thu, 13 Nov 2014 23:20:36 GMT

Awesome. That works great and is basically exactly what I was going for. Thanks a lot.

Re: Re: Bar Chart (upside down)

MarcoWedel — Thu, 13 Nov 2014 23:28:59 GMT

You're welcome

regards

Marco