Hi,
I'm creating an app in qlik sense using a combo chart. I want the combo chart to show bars for the yearly average of measurement data points between 2008-2014 with lines representing 1 sd above and below the average for yearly averages between 2008-2013 and I want these lines to extend across all years in the chart. I've created a formula for finding the standard deviation for the average of 2008-2013 result using set analysis for the measure across the dimension of year. However, it seems that Qlik Sense won't produce the results of the SD since the set analysis conflicts with the dimension of year in the combo chart. Is there a way I can set the result of the SD as a constant so this conflict doesn't arise, keeping in mind that I would still want it to change for selections across dimensions other than year?
Thanks,
Taylor
