Fill in missing month/year with previous session data
I'm sure it isn't that hard, but somehow I'm not getting what I want . . .
I hope someone can shine a little light on my little problem so I can go further.
The QlikView I have has some pre-calculations in which I want to add something.
I have a table containing something like shown below:
serialnumber
lastsession
lastsessiondate
monthyear
Configuration
123-456-789
4256
12-06-2011 11:56:18
06-2011
CONF_1
...
123-456-789
4687
18-09-2011 07:16:54
09-2011
CONF_2a
...
123-456-789
5689
22-11-2011 15:23:22
11-2011
CONF_2b
...
234-567-890
4268
19-06-2011 12:55:32
06-2011
CONF_1
...
234-567-890
4370
05-07-2011 21:15:43
07-2011
CONF_1a
...
234-567-890
4481
16-08-2011 10:21:53
08-2011
CONF_2a
...
345-678-901
4690
22-09-2011 09:51:12
09-2011
CONF_2a
...
345-678-901
5012
16-10-2011 18:32:45
10-2011
CONF_2b
...
345-678-901
5934
05-12-2011 19:37:11
12-2011
CONF_3
...
...
...
...
...
...
...
What I'm looking for is that the table expands with the missing month/years for the serialnumber, containing the lastsession and configuration info of the
