Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
LindRandom
Contributor
Contributor

Link two unrelated tables by Ward and date

Hi Everyone

I'm stuck trying to link tables which are essentially unrelated:

Table 1: is a list of test results associated with a ward on a particular day

e.g. 

Load

CultureDate as Date

AttributableWard as Ward

TestResults

From Table1

 

Table 2: Aggregated figure of bed days per month by ward

e.g.

Load 

Month as Date

Ward

OBDs

From Table2

 

When i link them It gives me a result, but the numbers of "TestResults" per month are not correct. I suspect it has something to do with the fact that the dates are in the same date format, but in table 2 are given as the first day of that month (for example, aggregated  May 2020 data is listed as 1/05/2020).

 

Does anyone have any advice?

Labels (4)
0 Replies