Trend Linear Calculation for future Month Year in Qlik Sense

[muthukumar77]

Hi,

I have the data month year wise, i need to calculate for future month year by using TREND LINEAR calculation. Here I have attached a sample data file with TREND calculation. Please find attachment.

 In Excel, TREND syntax is using to calculation the prediction data. Can anyone tell what we need to use to calculate Trend linear in Qlik Sense?

[tresesco]

You can perhaps use linear regression using linest_m(), linest_b() as explained here: https://community.qlik.com/t5/QlikView-App-Development/Forecasting-in-Qlikview/td-p/233589