Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lamnaresh
New Contributor II

How to split reference line based on Year in QlikSense

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

Tags (1)
3 Replies
ahaahaaha
Honored Contributor

Re: How to split reference line based on Year in QlikSense

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

lamnaresh
New Contributor II

Re: How to split reference line based on Year in QlikSense

Hi Andrey,

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

Regards,

Naresh.M

lamnaresh
New Contributor II

Re: How to split reference line based on Year in QlikSense

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