topic Re: Extract date from a week? in QlikView

Extract date from a week?

Fri, 29 Mar 2013 10:56:05 GMT

Hello,

I'm currently working on data where the date is set as week 1 week 2 week 3 (week 1 begining January first). Id like to know if there is a way to transform this data into dates when I load my table?

This is what my loading script looks like atm:

CrossTable(Weeks, Load, 4)

LOAD [People] as [Collab],

[Center],

[Projet],

[Activity],

Week1,

Week2,

Week3,

Week4,

Week5

......

Thanks in advance for any help concerning this matter!

Re: Extract date from a week?

Fri, 29 Mar 2013 11:07:01 GMT

Hi Loic,

i don't remember if such a function exists but what you can do is build a date from 01/01/13 (Date1)

using date + Nb

Where Nb is the number of days according to your week n° like

date = $(Date1) + ((WeekNo-1) * 7) + 1

regards

Chris

Re: Extract date from a week?

Fri, 29 Mar 2013 11:07:25 GMT

Hi,

just take the week number 1,2,3...... from week1,week2,week3,..... and multiply with 7 and add with jan 1.

Re: Extract date from a week?

Fri, 29 Mar 2013 13:32:20 GMT

Oh I didnt realise I could manipulate Dates so easily since I'm begining with Click view. Thanks for this answer!

Re: Extract date from a week?

Fri, 29 Mar 2013 13:33:03 GMT

Same answer at almost the same time as christian, thanks both!