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: 
BrianB
Contributor
Contributor

Create stacked Bar Chart with Linear Regression line

I'm trying to create a stacked bar chart that shows a linear regression line.  I am able to create a Bar chart with 2 dimensions and 1 measure, or I am able to create a Combo Chart with 1 dimension and 2 measures (where one of the measures is the linear regression line).  However, as the Bar Chart doesn't allow 2 measures, and the Combo Chart doesn't allow 2 dimensions, I am stuck creating a Stacked Bar Chart with the Linear Regression Line.

Note that I would want to create the Linear Regression Line on the primary Dimension (not the secondary dimension).

Creating the Regression Line was not easy, but I did find this excellent guide for creating the regression line here (I used section #2): https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-calculate-Linear-Trend/m-p/84332

Thanks in advance for any assistance you can provide.

Labels (2)
0 Replies