Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
muthukumar77
Partner - Creator III
Partner - Creator III

Trend Linear Calculation for future Month Year in Qlik Sense

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?

 

Muthukumar Pandiyan
Labels (2)
1 Reply
tresesco
MVP
MVP

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