topic Re: How to take average reference line by year in Visualization and Usability

How to take average reference line by year

Anonymous — Thu, 10 Aug 2017 05:40:12 GMT

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

Re: How to take average reference line by year

agigliotti — Thu, 10 Aug 2017 08:36:38 GMT

i guess you can't.

Re: How to take average reference line by year

sunny_talwar — Thu, 10 Aug 2017 11:27:38 GMT

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

Re: How to take average reference line by year

Anonymous — Fri, 11 Aug 2017 06:49:45 GMT

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

sunny_talwar — Fri, 11 Aug 2017 11:16:28 GMT

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.