Customized Trend Lines in stacked bar chart

[nadkalyan]

Hello,

We have a Stacked Bar Chart in Qlikview and need to add some customized data point Trend lines to it. Below is the desired chart we are looking for as final output -

We need Blue Dashed Lines and Red Dashed Line.The Blue Dashed lines need to be Set at the end of each quarter and the Red Dashed line need to set latest value.

Any ideas on how to acheive this. Trend lines weren't much help for us in acheiving this.

Thanks

Kalyan