Dynamic Reference Target line Qlik Desktop

Fri, 19 Aug 2016 14:09:40 GMT

Hello everyone,

I have a target line of 100,000 (volume) using a line graph on Qlik Sense Desktop

I am wondering if there is a way of having a target line per quarter that consists of the average of the volume.

For example,

taking the average volume from January to March and having their own target line and same goes with April - June

Would really appreciate if anyone can help,

Thanks

Re: Dynamic Reference Target line Qlik Desktop

Anonymous — Tue, 23 Aug 2016 09:56:46 GMT

I think I could calculate the average in the script, then you can add a line in your chart...

Month Quarter Average

Jan Q1 XX

Feb Q1 XX

Mar Q1 XX

Apr Q2 YY

May Q2 YY

Jun Q2 YY