year over year adding PCT

[alec1982]

hi all,

I have a chart that shows projected sales per year. the end user want to make it automated by adding pct to year over year..

the chart has

Year     Projected Sales

2011`    1000

2012     1000

2013     1200

2014     1300

2015     1400

The end users wants to the chart to show future projected sales by using a variable and apply it to the current year so if the variable is 10% then the table will look like

2016     (1400 * 10%)+1400

2017     (2016 value  *10%)+2016 value

and so one..

any ideas?

Best,

Alec

[ecolomer]

see this post, ...

Forecasting in Qlikview

[jagan]

Hi,

Try like this

Data:

LOAD

*

INLINE [

Year,     ProjectedSales

2011,`    1000

2012,     1000

2013,     1200

2014,     1300

2015,     1400];

Concatenate(Data)

LOAD

Peek(Year) + 1 AS Year,

Round(Peek(ProjectedSales) * 0.1) + Peek(ProjectedSales) AS ProjectedSales

AUTOGENERATE 10;   // I have given 10 for next 10 years, based on your requirement change this number.

Hope this helps you.

Regards,

Jagan.

[alec1982]

Thank you both but both solution dont work for me..  the variable is set by the user on the front end using a slider so the forecasting needs to be within the chart....

[jagan · Accepted solution]

Hi Alec,

Please find attached file for solution.

Regards,

Jagan.

[alec1982]

thank you for your help!