Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to get the date by using the year and week

can anyone help me in getting the date by using the year and the week

7 Replies
Not applicable
Author

What date? First date of the week?

you can use, for example:

=MakeWeekDate(2013, 1)

Regards,

Ricardo

Not applicable
Author

You know if you post the exact same question multiple times, you're probably going to get the same answers over and over again...

Not applicable
Author

my problem is iam having two table and i concatenated them

both of them are having year and week field

now after loading the date if i select year of table of i can not see the data for table 2

then i made makedate(year) as date

now i can see the data for both tables

again when i select the week

same problem only 1table data is seen now i am unable to understand how to connect them

Not applicable
Author

Share your app

Not applicable
Author

i am going with your exp

now my problem is

i am having 3 yrs data

in that 3 yrs i am missing the data os 1st week of 2013

it is not showing me the week number 1 and also data of it

unable to share app

Not applicable
Author

Hi

as far as i understand you have 2 tables with year and week fields but that hold diffrent values.

If you want to connect your 2 tables and see everything disregarding where you select from T1 or T2 you must load from the comon fields

T1:

LOAD ...

Year & '-' & Week    as   %W   // Builds a key, gives for example  2012-45  (week 45 , year 2012)

Year,             //  keep the field year

Week,          // keep the field week

...

FROM

concatenate

LOAD ...

Year & '-' & Week    as   %W   // Builds a key, gives for example  2012-45  (week 45 , year 2012)

Year,             //  keep the field year

Week

you then get 1 table T1 which hold every year-week coming from your 2 tables.

You can pick any week and it gives you every records where this week is located.

You can go further if you have date field. In this case use it to build your key.

best regards

christian

Not applicable
Author

... and if you post a duplicate idea, it will probably be flagged as duplicate.

Idea for Calendar Box Update