Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Dynamic Reference Target line Qlik Desktop

Capturegraph.PNG

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

1 Reply
elena888
Valued Contributor

Re: Dynamic Reference Target line Qlik Desktop

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

Community Browser