I have table joins from 2 different tables and they work, I was just wondering if there was a way to display values in QlikView based on the joining column so it will display values even where there aren't any. In this example I have two different table and I want to display null values where the NAME exists but there is no action or timestamp. My idea is that if I create an expression that shows the time since the timestamp will be subtracted from the current date and show how mush time between the two, which I have working now. I would also like the names that exist with the shift to appear as null or not opened or to place a timestamp that is 6 months ago and subtract that. I'm not sure if I have to do this with my query before QlikView or if QlikView can do this for me. I have different item number in table 2 but all the names exist.
Table 1
| NAME | Shift |
| Tom | A |
| Bob | A |
| John | A |
| Mike | B |
| Liam | B |
| Will | B |
Table 2
| NAME | ACTION | TIMESTAMP | ITEM |
| Bob | Open | 3/1/2019 3:05 | 1234 |
| John | Open | 3/2/2019 3:05 | 1234 |
| Mike | Open | 3/3/2019 3:05 | 1234 |
| Tom | Open | 3/4/2019 3:05 | 1234 |
| Tom | Open | 7/19/2018 0:00 | 5678 |
| Liam | Open | 7/20/2018 0:00 | 5678 |
| Will | Open | 7/21/2018 0:00 | 5678 |
| Mike | Open | 7/22/2018 0:00 | 5678 |
