Discussion board where members can learn more about Qlik Sense App Development and Usage.
Can someone tell how to do forecasting line chart for some financial data.
Thanks in advance.
which uses the very simple y=mx+b to calculate the straight line. If you project your [Date] forward, the line will be projected forward as well.
This created a set "MMM-YYYY" of 12 months behind, 3 months ahead:
Let varMinDate = Num(MonthStart(AddMonths(Today(),-12)));
Date(AddMonths($(varMinDate), + RecNo() - 1),'MMM-YYYY') as Date
Go through the below attached qvw files it might help u.