Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to take average reference line by year

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

4 Replies
agigliotti
Partner - Champion
Partner - Champion

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
Not applicable
Author

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.