Group by Week Number

MK_QSL — Wed, 04 Sep 2013 16:31:24 GMT

I have below table…

LOAD

[Part Number],
[Qty Coming],
Date
FROM …file name…

I want this table to convert…

[Part Number] and [SUM OF QTY] per Week.

Week need to be displayed Dynamically based on Today().

Also, number of weeks are not fixed but it's starting from current week.

Sample file enclosed.....

Result table should be like below.

Part Number	Week	Sum of Qty Coming
A	37	250
A	38	200
A	39	150
A	40	180
A	42	90
B	38	150
B	40	50
B	42	260
C	37	300
C	38	450
C	39	500
C	40	700
C	42	600
C	43	200
C	44	250
D	40	150
D	42	250
D	43	350
D	44	450

Re: Group by Week Number

Gysbert_Wassenaar — Wed, 04 Sep 2013 17:58:02 GMT

I don't understand what you mean with: Week need to be displayed Dynamically based on Today().

See attached qvw. The week numbers match the example result table you posted.

If you want different week numbers you could substract the week of today for example: week(Date) - week(today()). As I said it's not clear to me what you want with regards to the week numbers. So you'll have to figure that out yourself. The attached qvw should get you started.

topic Group by Week Number in QlikView

Group by Week Number

Re: Group by Week Number