Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
dgy
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
mov
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.

swuehl
MVP
MVP

Similar approach as Michael suggested, with some minor mods.

azimabadi
Creator III
Creator III

Are you sure that you have understood the Problem?