topic Re: Week Numbers to Week Date in QlikView

Week Numbers to Week Date

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

Hi! I hope someone can help me on this.

I have a dimension field [Week Number] that's being made into crosstable . How can I add a new field to convert them into weekly date where week 1 will fall on the current week., week 2 = Week 1 +7 and so on.

Thank you in advance.

Re: Week Numbers to Week Date

hector_munoz — Tue, 18 Apr 2017 04:25:50 GMT

Hi Caroline,

I attach you a sample in which you can assign a value order to each week: 0 for current, 1 for following, -1 for previous, ...

Hope it serves!

Regards,

Re: Week Numbers to Week Date

asgardd2 — Tue, 18 Apr 2017 06:12:39 GMT

Hello!

What do you want to get in the final table?

Did I understand correctly that you need this kind of the Table? :

Week 1	4/17/2017
Week 2	4/24/2017
Week 3	5/1/2017
Week 4	5/8/2017

Re: Week Numbers to Week Date

Anonymous — Tue, 18 Apr 2017 20:51:49 GMT

Hi! Hector ,

Where did you get this T1 week and T1 Monday fields? I can't find this in your excel week file.

This is what I have as table and I want to add a new dimension weekDate which is date format.

WeekDate:
CrossTable([Week Bucket], Data, 7)
LOAD Country,
Material,
Customer,
Description,
Type,,
Unit,
[Week Bucket] [Week 1] ,
[Week 2],
[Week 3],
[Week 4],
[Week 5],
[Week 6],
[Week 7],
[Week 8],
[Week 9],
[Week 10],
[Week 11],
[Week 12],
[Week 13],
[Week 14],
[Week 15],

Tks.

Re: Week Numbers to Week Date

Anonymous — Tue, 18 Apr 2017 20:55:52 GMT

Hi Anton,

This is my current table.

I want to add a new dimension weekDate in crosstable to look like below....

Tks.

Re: Week Numbers to Week Date

hector_munoz — Tue, 18 Apr 2017 20:58:40 GMT

Hi Caroline,

In my example [T1 Week] is like [Week Bucket] in yours and [T1 Monday] is like [Data].

Regards,