Week Conversion by using Month or Year. ( Date filed is not avilable on source)

Tue, 09 Jul 2013 05:55:43 GMT

Hi fouks,

Could you please help me to week conversion by using month or year. Actully week & date is not matianed one retailer. All the retailers has week conversion, We need to convert all retailes to one week level format. I attached the excel for source format.

Thanks & Regards,

Radha Krishna

RETAILER	STORE	YEAR	YEAR/MONTH	MONTH	MONTH NAME	UNIT SALES
A	1	2011	201105	5	MAY	230
B	2	2011	201106	6	JUNE	305
A	1	2011	201107	7	JULY	330
A	1	2011	201108	8	AUGUST	292
A	2	2011	201109	9	SEPTEMBER	437
B	1	2011	201110	10	OCTOBER	411
B	1	2011	201111	11	NOVEMBER	589
A	1	2011	201112	12	DECEMBER	603
C	1	2012	201201	1	JANUARY	523
A	1	2012	201202	2	FEBRUARY	711
C	1	2012	201203	3	MARCH	632
C	1	2012	201204	4	APRIL	596

Re: Week Conversion by using Month or Year. ( Date filed is not avilable on source)

tresB — Tue, 09 Jul 2013 06:06:29 GMT

Try something like:

LOAD RETAILER,

STORE,

YEAR,

[YEAR/MONTH],

MONTH,

[MONTH NAME],

[UNIT SALES],

Week(MakeDate(YEAR, MONTH,1)) as Week

FROM

topic Re: Week Conversion by using Month or Year. ( Date filed is not avilable on source) in QlikView

Week Conversion by using Month or Year. ( Date filed is not avilable on source)

Re: Week Conversion by using Month or Year. ( Date filed is not avilable on source)