Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Link by dates

Hi all,

I hope the community experts can help me on this.

I Have the follow situation:

Table SatO2

Patient ID     Date                    SatO2

1234           05/10 10:00:00          98

1234           05/10 10:00:30          98

1234           05/10 10:01:00          97

......

1234           05/10 11:00:00          99

Table FiO2

Patient ID     Date               FiO2

1234           05/10 09:30:00     21

1234           05/10 10:15:00     25

I need to join the tables based on the date so that the FiO2 value will value between to date/time without changing the number of registers of SatO2 table. This way:

Patient ID     Date                    SatO2   FiO2

1234           05/10 10:00:00          98      21

1234           05/10 10:00:30          98      21

1234           05/10 10:01:00          97      21

......

1234           05/10 11:00:00          99      25

I am stucked to join the two tables without a complete FK

I would really apreciate your help.

An working example would be great ! !

Regards,

Itamar