Dynamic Reference Target line Qlik Desktop

[#1]

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

[Anonymous]

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