Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cacosta35
Creator II
Creator II

Week Numbers to Week Date

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.

5 Replies
hector_munoz
Specialist
Specialist

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,

H

asgardd2
Creator III
Creator III

Hello!

What do you want to get in the final table?

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


Week 14/17/2017
Week 24/24/2017
Week 35/1/2017
Week 45/8/2017
cacosta35
Creator II
Creator II
Author

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.

cacosta35
Creator II
Creator II
Author

Hi Anton,

This is my current table.

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],

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

Tks.

hector_munoz
Specialist
Specialist

Hi Caroline,

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

Regards,

H