Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

Hi,

maybe this helps:

QlikCommunity_Thread_142061_Pic1.JPG.jpg

QlikCommunity_Thread_142061_Pic2.JPG.jpg

regards

Marco

Highlighted
Not applicable

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

Highlighted
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

Highlighted

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

Highlighted
Not applicable

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

Highlighted
Not applicable

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

Highlighted

You're welcome

regards

Marco