Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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.