Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
bentley32
Contributor
Contributor

can't calculate prediction with linest_m and linest_b

Hello all,

I dont know why i cant calculate the prediction with my formula,

 

I do have 2 dimension, yearmonth which is the registration date, and Dim which is the billing date months M+1 M+2 and so one

 

this is my formula 

 

if(REGROUPEMENT or REGROUPEMENT=0,REGROUPEMENT,
linest_m(total <[registration_date.autoCalendar.YearMonth]> aggr(if(REGROUPEMENT or REGROUPEMENT=0,REGROUPEMENT),Dim,[registration_date.autoCalendar.YearMonth]),Dim)*only({1}Dim)

+linest_b(total <[registration_date.autoCalendar.YearMonth]> aggr(if(REGROUPEMENT or REGROUPEMENT=0,REGROUPEMENT),Dim,[registration_date.autoCalendar.YearMonth]),Dim))

 

what i need is to calculate with the behaviour of the DIM (the billing dates) the future billing dates of the next registration date

this is my table and what i need to get filled and what i got ...

 

what need to get filled : 

bentley32_0-1636745981457.png

How it got filled wrongly : 

bentley32_1-1636746048890.png

 

 

Thanks for your help

 

1 Reply
bentley32
Contributor
Contributor
Author

anyone 🙂