topic Re: How to add reference area in line chart? in QlikView

How to add reference area in line chart?

Anonymous — Fri, 17 Nov 2017 09:23:31 GMT

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.

Re: How to add reference area in line chart?

m_woolf — Fri, 17 Nov 2017 15:08:43 GMT

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

Re: How to add reference area in line chart?

Anonymous — Mon, 20 Nov 2017 03:02:57 GMT

Hi man,

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

Re: How to add reference area in line chart?

marcus_sommer — Mon, 27 Nov 2017 15:54:55 GMT

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

Re: How to add reference area in line chart?

Anonymous — Fri, 22 Dec 2017 01:19:13 GMT

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