Multiple date fields - DateBridge | Table Associations

jere — Fri, 26 Jan 2024 11:56:26 GMT

Hello,

I'm quite new to Qlik Sense, and I have some association problem with my app.
I read about DateBridge approach when dealing with multiple date fields, and tried this approach, but there seems to be some problems.

I have two tables with date fields, one table with 5 date fields and other table with 3 date fields.

Ilmoitukset (announcements) table:
Where ad_bridge_id is an unique indentifier for announcement, and is connected to DateBridge table.
There is also user_id, which can be associated to Users-table.

Users table:
user_bridge_id is an unique identifier for user, and it's connected to DateBridge table.
User_id is the same id which is in the announcements table.

I created the DateBridge table to have:
CanonicalDate (connected to MasterCalendar)
UserId (if it is from user table, then the ad_bridge_id is null)
ad_bridge_if (comes from the announcements table, and takes the ad_bridge_id to ad_bridge_id field and the user_id to user_bridge_id field)
DateType (values changes based on the date field, 'createdCal', ('publishedCal')

The problem is that there is no association between Announcements table and Users table. I tried some other ways to connect them, but I got some synthetic key warnings/errors.

How could I fix it to have also association between Announcements table and Users table and still use single calendar? should just change the name of user_id in announcements table to match the name in the users table or should I somehow edit the DateBridge table.

Re: Multiple date fields - DateBridge | Table Associations

jochem_zw — Wed, 31 Jan 2024 08:16:29 GMT

remove user from bridge table and let it connect to the announcement table if fields are the same. Bridge table is only used for Canonical Date.

topic Re: Multiple date fields - DateBridge | Table Associations in Visualization and Usability

Multiple date fields - DateBridge | Table Associations

Re: Multiple date fields - DateBridge | Table Associations