topic Re: year over year adding PCT in QlikView

year over year adding PCT

alec1982 — Fri, 21 Aug 2015 21:48:56 GMT

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

Re: year over year adding PCT

ecolomer — Sat, 22 Aug 2015 05:25:13 GMT

see this post, ...

Forecasting in Qlikview

Re: year over year adding PCT

jagan — Sat, 22 Aug 2015 06:29:31 GMT

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.

Re: year over year adding PCT

alec1982 — Mon, 24 Aug 2015 13:20:24 GMT

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....

Re: year over year adding PCT

jagan — Mon, 24 Aug 2015 14:41:47 GMT

Hi Alec,

Please find attached file for solution.

Regards,

Jagan.

Re: year over year adding PCT

alec1982 — Mon, 24 Aug 2015 15:08:10 GMT

thank you for your help!