How to split reference line based on Year in QlikSense

[Anonymous]

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

[ahaahaaha]

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

[Anonymous]

Hi Andrey,

Thanks for quick updates, I am unable to see attached images. if you have qvf file please share across.

Regards,

Naresh.M

[Anonymous]

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