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

Bar Chart (upside down)

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.

1 Solution

Accepted Solutions
MarcoWedel

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

View solution in original post

7 Replies
MarcoWedel

Hi,

maybe this helps:

QlikCommunity_Thread_142061_Pic1.JPG.jpg

QlikCommunity_Thread_142061_Pic2.JPG.jpg

regards

Marco

Not applicable
Author

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

jduenyas
Specialist
Specialist

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

MarcoWedel

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

Not applicable
Author

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

Not applicable
Author

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

MarcoWedel

You're welcome

regards

Marco