Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

forecast with Drill down dimension



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. 


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

linest_m(total aggr(if(Count(BUG_ID),Count(BUG_ID)),

+linest_b(total aggr(if(Count(BUG_ID),Count(BUG_ID)),



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
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.