how to create a trend chart of KPI floating with actual YTD number

[#1]

Hi Guys,

     I am new to Qlikview, and would like to create a trend chart basing on the past actual number and Yearly target in Qlikview. The result should be similar to the chart as attachment.  Anyone have any idea on this?  Many thanks.

[ahaahaaha]

Hi Jason

As variant< may be as in attached file

Regards,

Andrey

[#3]

Hi Andrey,

     Thanks for your response.  I saw you adding the APC2017 data to achieve the graph, could we achieve by writing the expression since my file data was already complicated and we don't wan to keep maintaining this. I was thinking the logic for expression could be "(70-sum(YTD))/ Remaining months" or using what if analysis.  Please give me more advice.

      Many thanks.

Best regards,

Jason Liu