Is there a way to reverse the axis in a Chart object? I am looking for the QlikView equivalent of the "Values in reverse order" option in Excel charts.
I need to create a simple line chart showing the amount of downtime of a machine line over time, and since a higher value implies worse performance I would like to display the chart this way (i.e. a data point with 20% downtime should be lower than a a data point with 15% downtime).
There doesn't seem to be a setting in the chart properties to control this.
I have attached a QVW showing a data example... As you can see, when performance gets 'worse' the line chart goes up - this is not what I want to see
Maybe you would be happier with a graph of Availability... when machine Downtime goes down the machine Availability goes up. Availability = 1 - Downtime
