Discussion Board for collaboration on QlikView Scripting.
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.
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,
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