topic Re: Shade / fill with colour area between two lines in line chart in App Development

Shade / fill with colour area between two lines in line chart

charlie03 — Mon, 18 Dec 2023 14:42:24 GMT

Hi,

I'm trying to visualise a time series (sales per day) with a line chart. In this chart, I also have 3 additional lines: predicted sales, upper confidence interval of the predicted sales and lower CI.

So far i have plotted the four measures with lines. I would like however to paint the area between the upper and lower CI. Is there any way to fill in an area between two lines in a line chart?

Thanks!

Re: Shade / fill with colour area between two lines in line chart

pedrohenriqueperna — Tue, 19 Dec 2023 20:55:07 GMT

You can switch from "line" to "area" under "Appearances"

Re: Shade / fill with colour area between two lines in line chart

Daniel_Pilla — Tue, 19 Dec 2023 22:17:09 GMT

Hi @charlie03 ,

If you just want to shade the areas of the forecast, you can "hack" the line chart a bit to do this. You will need to use extra layers to color the lower bounds white of which you do not want shaded, and then stack on other layers for which you do want colored, subtracting from the others. It would take a while to explain what each layer does, so I've provided an example you can take a look at as well as a screenshot.

Also, it is worth mentioning that in Qlik Cloud, we have built in forecasting that does visualize like this. So this only applies for custom forecasting.

Maybe @Patric_Nordstrom has come up with something else!

Cheers,