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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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