topic Re: Forecasted orders in QlikView

Forecasted orders

ajsjoshua — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have two dates Upload week and forecast week ,i am using upload week in my calendar.

If user select uploadweek=2,it should display orders for uploadweek=1 and forecastweek=2

my answer should be 13

UploadWeek	ForecastWeek	orders
1	1	12
1	2	13
1	3	12
1	4	11
1	5	44
1	6	32
1	7	72
1	8	43
1	9	26
1	10	66
1	11	12
1	12	43
2	1	54
2	2	32
2	3	76
2	4	54
2	5	32
2	6	42
2	7	53
2	8	45
2	9	23
2	10	23
2	11	12
2	12	23

Re: Forecasted orders

MindaugasBacius — Wed, 15 Jun 2016 08:58:48 GMT

What is the logic?

If I select uploadweek = 1, why forecastweek = 2 not 3 or 10?

Re: Forecasted orders

ajsjoshua — Wed, 15 Jun 2016 09:01:52 GMT

Hi mindaugasbacius

Actually in every upload week we forecast orders for next 12 weeks.

Now i want to find what is forecasted orders for week 2.

Re: Forecasted orders

MindaugasBacius — Wed, 15 Jun 2016 09:06:56 GMT

Well, I guess than you should leave only rows with Forecast = 2 in your loading stage:

Where Forecast = 2;

In case you elaborate more details the other options may appear.

Re: Forecasted orders

sujeetsingh — Wed, 15 Jun 2016 09:09:47 GMT

Can you come in more words or provide a sample

Re: Forecasted orders

ajsjoshua — Wed, 15 Jun 2016 10:08:52 GMT

Hi mindaugasbacius sujeetsingh

PFA

Re: Forecasted orders

Digvijay_Singh — Wed, 15 Jun 2016 10:32:59 GMT

May be like this

Re: Forecasted orders

ajsjoshua — Wed, 15 Jun 2016 10:36:49 GMT

Hi,

digvijay

i want to show this dynamically

pls see the sample app.

Re: Forecasted orders

susovan — Wed, 15 Jun 2016 10:53:44 GMT

Hi johua,

Try this attachment,

Re: Forecasted orders

ajsjoshua — Wed, 15 Jun 2016 11:01:19 GMT

Hi susovan.g

I am using personal edition

pls share expression

Re: Forecasted orders

stephenedberkg — Wed, 15 Jun 2016 11:07:00 GMT

Dear susovan.g ,

share this expression. i am using personal edition.

Re: Forecasted orders

susovan — Wed, 15 Jun 2016 12:51:59 GMT

Hi Friends,

Try this script and use Sr.no as a dimension in list box.

LOAD *,

RowNo() as Sr.no;

LOAD * INLINE [

UploadWeek, ForecastWeek, orders

1, 1, 12

1, 2, 13

1, 3, 12

1, 4, 11

1, 5, 44

1, 6, 32

1, 7, 72

1, 8, 43

1, 9, 26

1, 10, 66

1, 11, 12

1, 12, 43

2, 1, 54

2, 2, 32

2, 3, 76

2, 4, 54

2, 5, 32

2, 6, 42

2, 7, 53

2, 8, 45

2, 9, 23

2, 10, 23

2, 11, 12

2, 12, 23,

];

Re: Forecasted orders

ajsjoshua — Wed, 15 Jun 2016 13:31:07 GMT

Hi,

Thats not my requirement find the sample attached.

Re: Forecasted orders

susovan — Thu, 16 Jun 2016 04:25:14 GMT

Hi Joshua,

PFA

Re: Forecasted orders

ajsjoshua — Thu, 16 Jun 2016 04:36:52 GMT

Hi,

I am using personal edition brother pls share the expression.

Re: Forecasted orders

susovan — Thu, 16 Jun 2016 04:39:12 GMT

Hi,

I do not use any calculated expression for the "Order".

Re: Forecasted orders

ajsjoshua — Thu, 16 Jun 2016 04:49:43 GMT

Hi susovan.g

The forecasted orders should be calculated whenever the user selects a week from the calendar(upload week).