topic Re: Linear forecast expression in QlikView

Linear forecast expression

kunkumnaveen — Mon, 29 May 2017 11:06:17 GMT

Hi,

i have to show coming next three years(2017,2018,2019) of spend based up (2014,2015,2016) data?

let say i my sample is

Year spend

2014 100

2015 200

2016 70

how much 2017 ?

will be for 2018 ?

2019 ?\

how to write a linear expression .......

Thanks

Re: Linear forecast expression

Anil_Babu_Samineni — Mon, 29 May 2017 11:12:15 GMT

Is this you are expecting?

Expression i used

If(Sum(Spend),Sum(Spend)

,Linest_M(TOTAL Aggr(if(Sum(Spend),Sum(Spend)),Year),Year)*Year

+Linest_B(TOTAL Aggr(if(Sum(Spend),Sum(Spend)),Year),Year))

Re: Linear forecast expression

kunkumnaveen — Mon, 29 May 2017 11:24:37 GMT

Hello Anil, thanks for your reply,

but i am not getting what you got..

i used this

load * inline

[

Fyear,fspend

2014,100

2015,200

2016,70

2017

2018

2019

];

i am not geeting 2017,2018,2019...Why?

Re: Linear forecast expression

kunkumnaveen — Mon, 29 May 2017 11:26:35 GMT

i have done a mistake now i realise it Year field i need to change

Re: Linear forecast expression

Anil_Babu_Samineni — Mon, 29 May 2017 11:26:53 GMT

You can use Fyear instead of Year and then look

Re: Linear forecast expression

kunkumnaveen — Mon, 29 May 2017 11:41:19 GMT

Hello Anil,

i wrote below expression in Line Style , so that those years will display in dots,

if(fspend>2016 , '<S3>')

but some how this is not working ,can u say wat i am missing plz

Re: Linear forecast expression

Anil_Babu_Samineni — Mon, 29 May 2017 11:43:50 GMT

There is no wrong on your expression, Seems working to me