topic Re: Expand Year month into week day in QlikView

Expand Year month into week day

Randomize1978 — Sat, 16 Nov 2024 18:09:51 GMT

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.

Re: Expand Year month into week day

edwin — Tue, 01 Sep 2020 18:14:08 GMT

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.

Re: Expand Year month into week day

edwin — Tue, 01 Sep 2020 18:18:06 GMT

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

Re: Expand Year month into week day

Randomize1978 — Tue, 01 Sep 2020 19:42:52 GMT

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

Re: Expand Year month into week day

Brett_Bleess — Wed, 16 Sep 2020 12:15:48 GMT

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