Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to combine 12 month rolling averages with monthly data on a single chart


I havea  chart that plots 12 month rolling average performance data for mutiple plants plotted over time and would like to add a target line to the chart

I am using the "asof" table method to generate the moving averages as per Calculating rolling n-period totals, averages or other aggregations by G Wassenaar.

When I add an expression for the traget, the individual plot lines for each plant get combined to one plot line, plotted against the target line

How do I retain the individual plot lines with teh target line?

Thanks in advance

Stephen

0 Replies