Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Axis value (offset)

Hi everyone

I'm trying to build a bar chart, similar to the one below, displaying the availability of machines. The target availability is 97 %, and I would like to display machines that have a higher availability as an rising bar, and a dropping bar for machines with a lower availability. I also want to display the actual values.

availability.JPG

Unfortunately, I cannot find a way to achieve this. I tried working with a 97 % offset, but that would mean that a 99 % value is displayed as 2%, and a 95 % availability as -2 %. So the bars are shown correctly, but not the values themselves.

I would have expected that this would be possible, since this is a pretty standard functionality in Excel as well.

Any ideas, anyone?

Thanks,

Frederic

1 Reply
Not applicable

Re: Axis value (offset)

I'm facing the same problem. Have you sovled it?