Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ayoub
Contributor III
Contributor III

Forecasting

Hello Community

i'm working on an application abt prediction ,  and i  wrote this expression : 

if(not (sum(Réserve)),
linest_m(total
aggr(if((sum(Réserve)),(sum(Réserve))),Mois_Sin),Mois_Sin)*Mois_Sin
+linest_b(total aggr(if((sum(Réserve) ),(sum(Réserve))),Mois_Sin),Mois_Sin))

it gives me the prediction for the rest of the year by month .
My question is how can i  add another dimension , because when i select fields from the dimension called usage, i don't get the prediction that  i want  

1 Reply
sunny_talwar

What were you hoping to see what did you get? It is not very clear from this statement -> 'I don't get the prediction that I want". A little more details will help.