Expand Year month into week day

[Randomize1978]

hello, i have year and month in a table that i would like to concatenate to other table which have weeks and days in addition.

so basically there are two ways that i am pointing at:

1.get an option in the concatenation where when the user will click on a week/day it will "understand"  that it is inside the Year month  and will show the data.

2.kind of expand the year month into weeks and days.

i will be glad to get an answer,thanks.

[edwin]

what i get is that you have two sets of data, one is at week level and another at month label.  
i would create a bridge table that links your table to a calendar.

so month Aug 2020 is linked to Aug 1 through Aug 31, 2020
week Aug 6, 2020 is linked to Aug 6 through Aug 12.

if user selects Aug 8, 2020 - it will associate with Aug 2020 (month year level) and at the same time Aug 6, 2020 at week level.

[edwin]

i was looking at wrong month.  week Aug 2, 2020 linked to Aug 2 through Aug 8

[Randomize1978]

Thank you, can you show it to me In a script? BTW I need the day as well

[Brett_Bleess]

Would check out the following Design Blog posts to see if they help at all:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Here is the base Design Blog link too in case you wish to search for other posts yourself:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett