Discussion Board for collaboration related to QlikView App Development.
Is there a way to reverse value on the X- axes in a charts?
I am using a Rank in the Expression and when I use this in a Chart is returns:
A B C D
Ofcourse I want it the other way around so number 1 is on top
A B C D
I can not find this, but it I am sure this is possible, somehow ....
Bit of a work around but this is a possible:
In the espression eg: =rank use: '=rank*-1' to invert the numbers - this will make the axis show in descending order.
Unfortunately I can't find a neater solution.
For even more work-around-ness add a white text object over all the minus signs so they appear as positives!? alternatively hide the axis all together and replace with your own in a text object which will be fine as long as the Y-axis never changes...which isn't likely!
Guess it could work.
Hope that helps,
Matt - Visual Analytics Ltd
Yes that is an option which I could use, and in this case I could use it (because the amount stays the same) But ther must be a better way right?
Thanks for the reply but that is not what this option is for:
When this option is checked, the values shown in the chart will be reversed, i.e. if the 10 highest values are shown and the box is checked the chart will then show the 10 lowest values.