Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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