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
previous session.
See sample below how it should look:
| serialnumber | lastsession | lastsessiondate | monthyear | configuration |
|
|---|
| 123-456-789 | 4256 | 12-06-2011 11:56:18 | 06-2011 | CONF_1 | ... |
| 123-456-789 | 4256 | 12-06-2011 11:56:18 | 07-2011 | CONF_1 | ... |
| 123-456-789 | 4256 | 12-06-2011 11:56:18 | 08-2011 | CONF_1 | ... |
| 123-456-789 | 4687 | 18-09-2011 07:16:54 | 09-2011 | CONF_2a | ... |
| 123-456-789 | 4687 | 18-09-2011 07:16:54 | 10-2011 | CONF_2a | ... |
| 123-456-789 | 5689 | 22-11-2011 15:23:22 | 11-2011 | CONF_2b | ... |
| 123-456-789 | 5689 | 22-11-2011 15:23:22 | 12-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 | ... |
| 234-567-890 | 4481 | 16-08-2011 10:21:53 | 09-2011 | CONF_2a | ... |
| 234-567-890 | 4481 | 16-08-2011 10:21:53 | 10-2011 | CONF_2a | ... |
| 234-567-890 | 4481 | 16-08-2011 10:21:53 | 11-2011 | CONF_2a | ... |
| 234-567-890 | 4481 | 16-08-2011 10:21:53 | 12-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 | 5012 | 16-10-2011 18:32:45 | 11-2011 | CONF_2b | ... |
| 345-678-901 | 5934 | 05-12-2011 19:37:11 | 12-2011 | CONF_3 | ... |
| ... | ... | ... | ... | ... |
|
|
|
|
|
|
|
thx in advance!!
Anita
