Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Employee
Employee

How can I invert or reverse the axis in my chart?

I have a bar chart showing the average employee rating by region.  The employee rating is a number anywhere between 1 and 3, but the problem is 1 is considered the highest rating, and 3 the lowest.  See the example below- what I'd like is for the axis to go from 3 at the x/y to 1, instead of 0 to 3.  The easy answer would be to multiply by -1 and show the negative value.  My problem is that the negative values always extend from the top of the chart down, I can't figure out a way to invert it.. I've attached an example qvw, thanks in advance for any help with this!

11-13-2012 10-30-51 AM.jpg

5 Replies
Champion III
Champion III

See if you like this one:

Inverse expression, as you tried:

- avg(Rating)

Create Bar Offset expression (attribute expression)

avg(Rating)-3

Regards,

Michael

Not applicable

Does anyone have any suggestion / solution ?

Not applicable


Please find attachment.

MVP
MVP

Similar approach as Michael suggested, with some minor mods.

Creator III
Creator III

Are you sure that you have understood the Problem?