Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lamnaresh
New Contributor II

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
Honored Contributor II

Re: How to take average reference line by year

i guess you can't.

Re: How to take average reference line by year

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

lamnaresh
New Contributor II

Re: How to take average reference line by year

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

Re: How to take average reference line by year

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.

Community Browser