Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
i was looking at wrong month. week Aug 2, 2020 linked to Aug 2 through Aug 8
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