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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
BrianDH
Creator II
Creator II

How do I Create a Trend Line in a Combo Chart or Bar Chart?

I have a chart (Dim = V_ENTERED_DT) (Mes = V_GROSS_AMT) (Alt-Mes =  linest_m(total aggr(if(sum(V_GROSS_AMT),sum(V_GROSS_AMT)),V_ENTERED_DT),V_ENTERED_DT)*  only({1}V_ENTERED_DT)+linest_b(total aggr(if(sum(V_GROSS_AMT),sum(V_GROSS_AMT)),V_ENTERED_DT),V_ENTERED_DT))

Secondary axis set to line.

 

I get no errors, i also get no lines.   Not sure where to go from here.

 

Labels (2)
1 Solution

Accepted Solutions
BrianDH
Creator II
Creator II
Author

Solved:  First create a Line Chart, then after you see your trend line convert to a Combo Chart

https://youtu.be/dBrKlORa1Tc

 

View solution in original post

1 Reply
BrianDH
Creator II
Creator II
Author

Solved:  First create a Line Chart, then after you see your trend line convert to a Combo Chart

https://youtu.be/dBrKlORa1Tc