Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to see a linear trendline of my data plotted. How can I do that in Qlik sense?
Thanks,
hi
you can use an expression similiar to this one
LinEst_M(total aggr(sum(LineAmount),[OrderDate.autoCalendar.YearMonth]),[OrderDate.autoCalendar.YearMonth])*[OrderDate.autoCalendar.YearMonth]+
LinEst_b(total aggr(sum(LineAmount),[OrderDate.autoCalendar.YearMonth]),[OrderDate.autoCalendar.YearMonth])
where linest_M is giving you back the m value of the equation y=mx+b
and linest_b give you back the b
hi i can't upload the qvf file seems like a problem in the community
so you can download an example from here