Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Linear interpolation

Hi,

I need your help to fix this expression that i am using to get the value of a known point x :

Here is the expression :

Sum({$<[Due Year] ={">=$(=(max([Due Year])-($(V_YearBack))))  <=$(=(max([Due Year]) ))"},

Elapse ={"=$(=(Min({1} Aggr(Min({$<[Due Year] ={">=$(=(max([Due Year])-($(V_YearBack))))  <=$(=(max([Due Year]) ))"},

Elapse ={">=$(=(max(Elapse)))"}>} Elapse),[Due Month],[Due Year]))))"}>}Sales_$(V_Currency))/1000

This expression shows an error but i cannot see where is it ?

My known point x i get it with this expession :

=Min({1} Aggr(Min({$<[Due Year] ={">=$(=(max([Due Year])-($(V_YearBack))))  <=$(=(max([Due Year]) ))"},

Elapse ={">=$(=(max(Elapse)))"}>} Elapse),[Due Month],[Due Year]))

Can you please help to fix it ?

Thanks

1 Reply

Re: Linear interpolation

This is a duplicate post.  Someone already replied here: Linear interpolation

Community Browser