Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Heena
New Contributor III

forecast with Drill down dimension

Hi,

 

I have to show the forecast of count(BUG_ID), for the dates---> Year-Quarter-Month-Date ,Drill down.

i found the below solution for forecast, and it worked for one date field for example month. 

https://community.qlik.com/t5/New-to-Qlik-Sense/FORECAST-and-TREND-function-of-Excel-in-Qlik-Sense/t...

the measure expression, i used for month field(dimension) is as below,

=if(Count(BUG_ID),Count(BUG_ID),
linest_m(total aggr(if(Count(BUG_ID),Count(BUG_ID)),
[Month]),[Month])*

only([Month])
+linest_b(total aggr(if(Count(BUG_ID),Count(BUG_ID)),
[Month]),[Month]))

 

 

Can anyone help me with measure expression, that works to forecast count(BUG_ID) with the Drill down(Year-Quarter-Month-Date) ?

i have created the drill-Down Dimension---> Year-Quarter-Month-Date.

 

 

1 Reply
NhanNguyen
New Contributor III

Re: forecast with Drill down dimension

You are now hard-coding Month as your dimension. Try to replace it with your Drill-down dimension and see if it works.