Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
How to split reference line based on Year in QlikSense..?
I have a line chart, and need to create reference line, but the reference line should split based on year. Here i have attached my requirement screenshot. Can you please help on this problem.
I have taken In X-axis : Year and Month Dimension.
Thanks,
Naresh
Hi,
I tried to solve your task. Unfortunately, the reference lines do not perceive the values given in the form of formulas (Chart 1 of the attached file). Limit the length of the reference lines, applying the appropriate expressions, failed.
As a workaround, additional expressions can be used instead of the reference lines, as shown in Chart 2 in the attached file.
Regards,
Andrey
Hi Andrey,
Thanks for quick updates, I am unable to see attached images. if you have qvf file please share across.
Regards,
Naresh.M
Hi Andrey,
Thanks for quick updates, Here i am attaching my qvf file and need to add reference line based on below formula.
Formula of reference line =avg(Revenue) + 3*Stdev(Revenue)
Note : the reference line should show the value of each year wise.
Regards,
Naresh.m