How to add reference area in line chart?

[Anonymous]

Hi folks,

In the QlikView line chart, I could find the reference line, but how could I define the reference area? Sample one is attached. For example I want to set the range from 95% to 100% is in green, etc.

[m_woolf]

If your y axis scale doesn't change, you could use an image in the chart background.

[Anonymous]

Hi man,

Thanks a lot for your reply. Unfortunately, the y axis scale will be dynamic based on the metrics value.

[marcus_sommer · Accepted solution]

I could imagine that it might be possible with two charts (one as the normal line-chart and the other as a line-chart with the fourth option in tab design) which are laying over eachother with the appropriate adjustments on the various layout-options - hiding title, border, axis and so on respectively setting them to transparent with argb(0,0,0,0).

To sychronize both chart-axis you need to define the scaling with expressions maybe with something like this:

ceil((max(Total YourExpression) - min(Total YourExpression)) / NumberOfIntervals, RoundingArea)

I think it will need some effort to build such a construct but you should get quite near to what you want.

- Marcus

[Anonymous]

Thanks a lot, man. I will try your solution.