Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.