topic Re: Week Comparison Problem in QlikView

Week Comparison Problem

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

Hi all,

I want to compare the orders for all weeks

I have two years of data 2015 and 2016

i am unable to compare 52 week of 2015 and 8 week of 2016.

i am using this expression

=sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {"=$(=Max(Week_UP))"},Year=,Month=,Quarter=>}Orders)

Regards,

Joshua.

Re: Week Comparison Problem

MK_QSL — Wed, 22 Jun 2016 06:15:47 GMT

Not understood what exactly you want to do... can you explain in brief please..

Re: Week Comparison Problem

ajsjoshua — Wed, 22 Jun 2016 06:28:55 GMT

Hi Manish,

Pls find the sample attached.

Re: Week Comparison Problem

ajsjoshua — Wed, 22 Jun 2016 06:47:05 GMT

Hi mrkachhiaimp

Bro actually if user select week 8 in Year=2016 it should show orders value for week 8 which has been forecasted on 52 week of year 2015 .

Re: Week Comparison Problem

MK_QSL — Wed, 22 Jun 2016 07:41:47 GMT

I still don't get the logic. Can you explain by taking two examples... say select Week 10 and what result you are expecting.. Select week 20 and provide the result you are looking for..

Re: Week Comparison Problem

ajsjoshua — Wed, 22 Jun 2016 07:58:20 GMT

Hi mrkachhiaimp

If i select Week_Up=10 then it should display orders for week 10 which has been forecasted on week_Up=2

If i select Week_Up=20 then it should display orders for week 20 which has been forecasted on week_Up=12

Its working fine for these two but its not giving answers for week_Up =8

week_Up =7

week_Up =6

week_Up =5

week_Up =4

week_Up =3

week_Up =2

week_Up =1

Re: Week Comparison Problem

MK_QSL — Wed, 22 Jun 2016 08:00:29 GMT

But also provide output... I mean sum(orders) you are looking for..

Re: Week Comparison Problem

ajsjoshua — Wed, 22 Jun 2016 08:07:40 GMT

Hi,

For week_up=20

Forecasted 8 orders=380.8796

Re: Week Comparison Problem

MK_QSL — Wed, 22 Jun 2016 08:17:11 GMT

Create a Straight/Pivot Table

Dimension

Week_UP

Expression

=SUM({<Week_UP = {"=Week_UP + 8 = Week"}>}Orders)

Re: Week Comparison Problem

ajsjoshua — Wed, 22 Jun 2016 08:23:34 GMT

Hi mrkachhiaimp

I am not getting any values.

Regards,

Joshua.

Re: Week Comparison Problem

MK_QSL — Wed, 22 Jun 2016 08:27:30 GMT

FYI

Re: Week Comparison Problem

ajsjoshua — Wed, 22 Jun 2016 08:28:29 GMT

Hi mrkachhiaimp

Bro i am using personal edition .

Re: Week Comparison Problem

MK_QSL — Wed, 22 Jun 2016 08:44:59 GMT

Are your week selection is Week_UP or Week?

I mean when you are saying that you have selected week 20... that is Week_UP 20 or Week 20?

Re: Week Comparison Problem

ajsjoshua — Wed, 22 Jun 2016 09:36:37 GMT

Hi Manish,

Week_Up=20

Re: Week Comparison Problem

MK_QSL — Wed, 22 Jun 2016 09:47:56 GMT

It's too much confusing... better if you provide an excel file with the selection and output you require with better explanation.

Re: Week Comparison Problem

ajsjoshua — Wed, 22 Jun 2016 10:03:14 GMT

Hi Manish,

I will prepare the excel bro wait.

Re: Week Comparison Problem

ajsjoshua — Wed, 22 Jun 2016 10:19:43 GMT

Hi Manish,

PFA

Every Week_Up has 12 forecasted week,Now I want to find the orders for week_up=1 year=2016 which has been forecasted on week_up=46 ,year=2015 ,

the answer is 33

Re: Week Comparison Problem

MK_QSL — Wed, 22 Jun 2016 10:29:51 GMT

Every Week_Up has 12 forecasted week,Now I want to find the orders for week_up=1 year=2016 which has been forecasted on week_up=46 ,year=2015 ,the answer is 33

Not understood this sentence..

I understood that for every Week_Up you have 12 forecast week.

But not understood

I want to find the orders for week_up=1 year=2016 which has been forecasted on week_up=46 ,year=2015 ,the answer is 33

Re: Week Comparison Problem

ajsjoshua — Wed, 22 Jun 2016 10:38:44 GMT

Hi Manish,

Week_Up is my calendar,

when user selects week_up=1 and year=2016

then i want to show the orders for forecastweek=1 which has been forecasted 8 weeks before i.e in week_Up=46 and Year-2015.

46	46	2015	54
46	47	2015	54
46	48	2015	54
46	49	2015	54
46	50	2015	54
46	51	2015	54
46	52	2015	54
46	53	2015	54
46	1	2016	33
46	2	2016	33
46	3	2016	33
46	4	2016	33

when user selects week_up=1 and year=2016

The output should be 33.

Re: Week Comparison Problem

MK_QSL — Wed, 22 Jun 2016 10:42:04 GMT

When user select Week_Up = 1 and Year = 2016, you have below data..

Week_Up	Forcastweek	Year	orders
1	1	2016	84
1	2	2016	19
1	3	2016	19
1	4	2016	19
1	5	2016	19
1	6	2016	19
1	7	2016	19
1	8	2016	19
1	9	2016	19
1	10	2016	19
1	11	2016	19
1	12	2016	19