topic Re: Forecast in QlikView

Forecast

Wed, 25 Nov 2020 16:16:04 GMT

Hi every one ,

I have a excel like below, i want a bar chart that show sale amount for exist year and show forecast sales for 2016(next year) ,

which function i can do ?

please help me ?

Best Regards

Hamide

Re: Forecast

Anil_Babu_Samineni — Sat, 06 Aug 2016 07:12:42 GMT

Above(Sum(Sales))

Re: Forecast

Sat, 06 Aug 2016 07:50:59 GMT

Thanks for your reply , but it's not my answer .

i write below expression :

if(sum(Sale),sum(Sale)

,linest_m(total aggr(if(sum(Sale),sum(Sale)),Year),Year)*Year

+linest_b(total aggr(if(sum(Sale),sum(Sale)),Year),Year))

but my expression doesn't show sales amount for 2016

Re: Forecast

Anil_Babu_Samineni — Sat, 06 Aug 2016 07:54:02 GMT

Can you please post small Application

Re: Forecast

Kushal_Chawda — Sat, 06 Aug 2016 08:00:16 GMT

You need to have Year 2016 in data

LOAD * Inline [

Year,Value

2010,100

2011,200

2012,250

2013,150

2014,200

2015,120

2016 ];

Expression:

=if(Year<>'2016',sum(Value),

linest_m(total aggr(if(sum(Value),sum(Value)),Year),Year)*Year

+linest_b(total aggr(if(sum(Value),sum(Value)),Year),Year))

Re: Forecast

Sat, 06 Aug 2016 10:55:30 GMT

Thanks Kushal,

For static data like load inline it is ok but for dynamic data which solution you offer,

My document is connected to sql server and i haven't next year in my data.

Regards

Hamide

Re: Forecast

Kushal_Chawda — Sat, 06 Aug 2016 11:02:01 GMT

You can manually add Year like below

YourData:

LOAD Year,

...

FROM Table;

concatenate(YourData)

LOAD * inline [

Year

2016 ];