topic Re: Qlikview chart: adding a forecast manually in QlikView

Qlikview chart: adding a forecast manually

Mon, 23 Nov 2015 15:04:01 GMT

Dear all,

I have been struggling with the problem mentioned below for the last couple of days and after spending hours searching through the internet I decided to create my own thread.

Below you can find a chart (Quantity) which shows the sum of the quantity of materials bought in a year (on monthly basis). Unfortunately we buy our materials on a irregular basis which can be seen below (full accumulation). The red line should show the the Demand for that year (see excel below).

All I would like is a very simple diagonal line (demand) throughout the year, since I ave set the option to show all values (including 0) I cannot seem to achieve the diagonal line with the demand (ie. Demand = 120, Jan = 10, Feb = 20 Mar = 30 etc.).

Does anyone know how I can get a diagonal line? The forecast total is done on a yearly basis and is divided by 12 in each month.

Appreciate all the help I can get one this!!!!

Kind regards,

Neil

Material

Demand 2015

Demand 2015 maand (=Demand 2015/12)

Re: Qlikview chart: adding a forecast manually

swuehl — Mon, 23 Nov 2015 17:37:50 GMT

Maybe just add records for each month / material in your data model that describes the demand:

TMP:

LOAD Material, Demand2015 / 12 as MonthlyDemand

FROM YourDemandTable;

JOIN (TMP)

LOAD Month(Makedate(2015,recno())) as Month

AUTOGENERATE 12;

CONCATENATE (YourFactTable)

LOAD * RESIDENT TMP;

DROP TABLE TMP;

Re: Qlikview chart: adding a forecast manually

effinty2112 — Mon, 23 Nov 2015 20:20:50 GMT

Hi Neil,

See if this fits the bill. Enter your annual forecast into the Input box.

Regards

Re: Qlikview chart: adding a forecast manually

Tue, 24 Nov 2015 15:42:04 GMT

Dear Andrew,

First of all, thank you for your efforts! I had a shot at swuehls solution but most likely due to my lack of knowledge in excel/Qlikview I have not been successfull.

I tried your solution Andrew (seems quite simple) but again it doesnt work, I copied the expression (and changed the field to [Demand 2015] but the line still isnt showing show. What am I doing wrong?

Appreciate the help guys!

Re: Qlikview chart: adding a forecast manually

effinty2112 — Tue, 24 Nov 2015 19:42:47 GMT

Hi Neil,

Your expression looks a bit odd. Change the name of your variable to vDemand2015. Don't use spaces and the v prefix is good practice to identify this as a variable. Edit the expression to read RowNo()*$(vDemand2015)/12, no square brackets.

Make sure a value is assigned to the variable (using an inputbox is the obvious wayto do so) and let me know if it still doesn't work.

Regards