How to take average reference line by year

[Anonymous]

Hi Everyone,

Since I am new to Qliksense, I have one doubt, below is my scenario.

I have a line chart with multiple years data and i want to display reference line for 2014 year only  by average but  when i have write a formula the line is showing for all years, as per my condition it should show till 2014 Dec, here i am attaching my screen shot. please help me on this topic.

Thanks,

Modipalli

[agigliotti]

i guess you can't.

[sunny_talwar]

May be use set analysis or if statement to restrict your line to Dec 2014.... If you can share a sample, we might be able to help you better here

[Anonymous]

Hi Sunny,

Please find the attached sample file and let me know if possible.

Note: need to display through reference line only

Formula : Avg(Revenue) for 2014 - Reference line

but graph need to display 2014,2015 and 2016 data

[sunny_talwar]

I was hoping for you to attach your qvf file or load the above data into qvf and create the chart for me. Because I am new to QlikSense, I am not sure how to recreate the chart you have in your dashboard.