Table joins and data viewed in qlikview

[albz91184]

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

[chrismarlow]

Hi,

You could try a trick of adding an expression and hiding it. So add Only(NAME) as your expression & then on 'Presentation' tab select the column & then hide column;

Cheers,

Chris.