Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
choubeji
Contributor
Contributor

Trend Function of Excel in Qlik Sense

We have existing application on Excel and we have want to migrate into Qlik Sense however Excel has in built Trend Function which are used widely in the assignment. Please suggest whether we can use Trend Function in Qlik Sense. We need to display the Trend Function result as Percentage which is working properly in Excel

Labels (2)
1 Reply
segador_
Partner
Partner

Hi!

You can use linest_m and linest_b functions in expression editor to calculate the trend.

For example, if you have a YearValue - field, and SUM(Sales) measure then you should write this expression for trend.

linest_m(total aggr(SUM(Sales),YearValue ),YearValue )*YearValue +linest_b(total aggr(SUM(Sales),YearValue ),YearValue )

 

More information about these functions you can find in this topic:

https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Statisti...

Regards, Igor.