Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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