Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
michaelcostner
Contributor II
Contributor II

Adding Average Lines to Trellis

Hi Everyone,

I'm creating a trellis line chart which a tracks a value year over month. I'd like to add a line indicating the average value per year to each section of the trellis chart. I've tried following this solution:

Reference lines for each section of the trellis chart

I've attached a small application as an example. I can calculate the correct yearly average, however I'm not able to extend that value to all months in the given year. I would like my chart to look like the below image.

Thanks!

Michael

graph_sample.png

8 Replies
Anonymous
Not applicable

do you want to achieve 12 separate  data points for 2014?

michaelcostner
Contributor II
Contributor II
Author

Yes, I believe that's what I want. As long as the average line extends across all months for each year.

Anonymous
Not applicable

could you add your excel file please, I think you'll have to add the missing values at script level

michaelcostner
Contributor II
Contributor II
Author

Here it is. Thanks.

Anonymous
Not applicable

not sure, if 100% correct, but I think the basic idea should be clear ...

Anonymous
Not applicable

or use a separate calendar....

michaelcostner
Contributor II
Contributor II
Author

Thanks for the suggestions Robin. Is there any way to calculate the averages without changing the script? I was hoping this could be done by writing an expression.

Thanks

Anonymous
Not applicable

I don't think that it is possible without changing the script because the values just don't exist for 2014...

(could be that  I am wrong )

For this chart type there's no "populate missing" option as it exists for pivot charts.