topic Fill in missing month/year with previous session data in QlikView https://community.qlik.com/t5/QlikView/Fill-in-missing-month-year-with-previous-session-data/m-p/293575#M108926 <HTML><HEAD></HEAD><BODY><P>I'm sure it isn't that hard, but somehow I'm not getting what I want . . . </P><P></P><P>I hope someone can shine a little light on my little problem so I can go further.</P><P>The QlikView I have has some pre-calculations in which I want to add something.</P><P></P><P>I have a table containing something like shown below:</P><P></P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>serialnumber<BR /></STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>lastsession<BR /></STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><P><STRONG>lastsessiondate</STRONG></P></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>monthyear</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Configuration<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG><BR /></STRONG></SPAN></TH></TR><TR><TD>123-456-789</TD><TD>4256</TD><TD>12-06-2011 11:56:18</TD><TD>06-2011</TD><TD>CONF_1</TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD>4687</TD><TD>18-09-2011 07:16:54</TD><TD>09-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD>5689</TD><TD>22-11-2011 15:23:22</TD><TD>11-2011</TD><TD>CONF_2b</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4268</TD><TD>19-06-2011 12:55:32</TD><TD>06-2011</TD><TD>CONF_1</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4370</TD><TD>05-07-2011 21:15:43</TD><TD><P>07-2011</P></TD><TD>CONF_1a</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4481</TD><TD>16-08-2011 10:21:53</TD><TD>08-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>4690</TD><TD>22-09-2011 09:51:12</TD><TD>09-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>5012</TD><TD>16-10-2011 18:32:45</TD><TD>10-2011</TD><TD>CONF_2b</TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>5934</TD><TD>05-12-2011 19:37:11</TD><TD><P>12-2011</P></TD><TD>CONF_3</TD><TD>...</TD></TR><TR><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD></TR></TBODY></TABLE><P></P><P></P><P>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 </P><P>previous session.</P><P></P><P>See sample below how it should look:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>serialnumber</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>lastsession</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>lastsessiondate</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>monthyear</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>configuration</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG><BR /></STRONG></SPAN></TH></TR><TR><TD>123-456-789</TD><TD>4256</TD><TD>12-06-2011 11:56:18</TD><TD>06-2011</TD><TD>CONF_1</TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD><EM>4256</EM></TD><TD><EM>12-06-2011 11:56:18</EM></TD><TD><STRONG>07-2011</STRONG></TD><TD><EM>CONF_1</EM></TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD><EM>4256</EM></TD><TD><EM>12-06-2011 11:56:18</EM></TD><TD><STRONG>08-2011</STRONG></TD><TD><EM>CONF_1</EM></TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD>4687</TD><TD>18-09-2011 07:16:54</TD><TD>09-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD><EM>4687</EM></TD><TD><EM>18-09-2011 07:16:54</EM></TD><TD><STRONG>10-2011</STRONG></TD><TD><EM>CONF_2a</EM></TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD>5689</TD><TD>22-11-2011 15:23:22</TD><TD>11-2011</TD><TD>CONF_2b</TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD><EM>5689</EM></TD><TD><EM>22-11-2011 15:23:22</EM></TD><TD><STRONG>12-2011</STRONG></TD><TD><EM>CONF_2b</EM></TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4268</TD><TD>19-06-2011 12:55:32</TD><TD>06-2011</TD><TD>CONF_1</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4370</TD><TD>05-07-2011 21:15:43</TD><TD>07-2011</TD><TD>CONF_1a</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4481</TD><TD>16-08-2011 10:21:53</TD><TD>08-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD><EM>4481</EM></TD><TD><EM>16-08-2011 10:21:53</EM></TD><TD><STRONG>09-2011</STRONG></TD><TD><EM>CONF_2a</EM></TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD><EM>4481</EM></TD><TD><EM>16-08-2011 10:21:53</EM></TD><TD><STRONG>10-2011</STRONG></TD><TD><EM>CONF_2a</EM></TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD><EM>4481</EM></TD><TD><EM>16-08-2011 10:21:53</EM></TD><TD><STRONG>11-2011</STRONG></TD><TD><EM>CONF_2a</EM></TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD><EM>4481</EM></TD><TD><EM>16-08-2011 10:21:53</EM></TD><TD><STRONG>12-2011</STRONG></TD><TD><EM>CONF_2a</EM></TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>4690</TD><TD>22-09-2011 09:51:12</TD><TD>09-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>5012</TD><TD>16-10-2011 18:32:45</TD><TD>10-2011</TD><TD>CONF_2b</TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD><EM>5012</EM></TD><TD><EM>16-10-2011 18:32:45</EM></TD><TD><STRONG>11-2011</STRONG></TD><TD><EM>CONF_2b</EM></TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>5934</TD><TD>05-12-2011 19:37:11</TD><TD>12-2011</TD><TD>CONF_3</TD><TD>...</TD></TR><TR><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P></P><P>thx in advance!!</P><P></P><P>Anita</P></BODY></HTML> Mon, 12 Dec 2011 12:21:15 GMT Anonymous 2011-12-12T12:21:15Z Fill in missing month/year with previous session data https://community.qlik.com/t5/QlikView/Fill-in-missing-month-year-with-previous-session-data/m-p/293575#M108926 <HTML><HEAD></HEAD><BODY><P>I'm sure it isn't that hard, but somehow I'm not getting what I want . . . </P><P></P><P>I hope someone can shine a little light on my little problem so I can go further.</P><P>The QlikView I have has some pre-calculations in which I want to add something.</P><P></P><P>I have a table containing something like shown below:</P><P></P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>serialnumber<BR /></STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>lastsession<BR /></STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><P><STRONG>lastsessiondate</STRONG></P></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>monthyear</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Configuration<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG><BR /></STRONG></SPAN></TH></TR><TR><TD>123-456-789</TD><TD>4256</TD><TD>12-06-2011 11:56:18</TD><TD>06-2011</TD><TD>CONF_1</TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD>4687</TD><TD>18-09-2011 07:16:54</TD><TD>09-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD>5689</TD><TD>22-11-2011 15:23:22</TD><TD>11-2011</TD><TD>CONF_2b</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4268</TD><TD>19-06-2011 12:55:32</TD><TD>06-2011</TD><TD>CONF_1</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4370</TD><TD>05-07-2011 21:15:43</TD><TD><P>07-2011</P></TD><TD>CONF_1a</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4481</TD><TD>16-08-2011 10:21:53</TD><TD>08-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>4690</TD><TD>22-09-2011 09:51:12</TD><TD>09-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>5012</TD><TD>16-10-2011 18:32:45</TD><TD>10-2011</TD><TD>CONF_2b</TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>5934</TD><TD>05-12-2011 19:37:11</TD><TD><P>12-2011</P></TD><TD>CONF_3</TD><TD>...</TD></TR><TR><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD></TR></TBODY></TABLE><P></P><P></P><P>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 </P><P>previous session.</P><P></P><P>See sample below how it should look:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>serialnumber</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>lastsession</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>lastsessiondate</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>monthyear</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>configuration</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG><BR /></STRONG></SPAN></TH></TR><TR><TD>123-456-789</TD><TD>4256</TD><TD>12-06-2011 11:56:18</TD><TD>06-2011</TD><TD>CONF_1</TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD><EM>4256</EM></TD><TD><EM>12-06-2011 11:56:18</EM></TD><TD><STRONG>07-2011</STRONG></TD><TD><EM>CONF_1</EM></TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD><EM>4256</EM></TD><TD><EM>12-06-2011 11:56:18</EM></TD><TD><STRONG>08-2011</STRONG></TD><TD><EM>CONF_1</EM></TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD>4687</TD><TD>18-09-2011 07:16:54</TD><TD>09-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD><EM>4687</EM></TD><TD><EM>18-09-2011 07:16:54</EM></TD><TD><STRONG>10-2011</STRONG></TD><TD><EM>CONF_2a</EM></TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD>5689</TD><TD>22-11-2011 15:23:22</TD><TD>11-2011</TD><TD>CONF_2b</TD><TD>...</TD></TR><TR><TD>123-456-789</TD><TD><EM>5689</EM></TD><TD><EM>22-11-2011 15:23:22</EM></TD><TD><STRONG>12-2011</STRONG></TD><TD><EM>CONF_2b</EM></TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4268</TD><TD>19-06-2011 12:55:32</TD><TD>06-2011</TD><TD>CONF_1</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4370</TD><TD>05-07-2011 21:15:43</TD><TD>07-2011</TD><TD>CONF_1a</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD>4481</TD><TD>16-08-2011 10:21:53</TD><TD>08-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD><EM>4481</EM></TD><TD><EM>16-08-2011 10:21:53</EM></TD><TD><STRONG>09-2011</STRONG></TD><TD><EM>CONF_2a</EM></TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD><EM>4481</EM></TD><TD><EM>16-08-2011 10:21:53</EM></TD><TD><STRONG>10-2011</STRONG></TD><TD><EM>CONF_2a</EM></TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD><EM>4481</EM></TD><TD><EM>16-08-2011 10:21:53</EM></TD><TD><STRONG>11-2011</STRONG></TD><TD><EM>CONF_2a</EM></TD><TD>...</TD></TR><TR><TD>234-567-890</TD><TD><EM>4481</EM></TD><TD><EM>16-08-2011 10:21:53</EM></TD><TD><STRONG>12-2011</STRONG></TD><TD><EM>CONF_2a</EM></TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>4690</TD><TD>22-09-2011 09:51:12</TD><TD>09-2011</TD><TD>CONF_2a</TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>5012</TD><TD>16-10-2011 18:32:45</TD><TD>10-2011</TD><TD>CONF_2b</TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD><EM>5012</EM></TD><TD><EM>16-10-2011 18:32:45</EM></TD><TD><STRONG>11-2011</STRONG></TD><TD><EM>CONF_2b</EM></TD><TD>...</TD></TR><TR><TD>345-678-901</TD><TD>5934</TD><TD>05-12-2011 19:37:11</TD><TD>12-2011</TD><TD>CONF_3</TD><TD>...</TD></TR><TR><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P></P><P>thx in advance!!</P><P></P><P>Anita</P></BODY></HTML> Mon, 12 Dec 2011 12:21:15 GMT https://community.qlik.com/t5/QlikView/Fill-in-missing-month-year-with-previous-session-data/m-p/293575#M108926 Anonymous 2011-12-12T12:21:15Z Fill in missing month/year with previous session data https://community.qlik.com/t5/QlikView/Fill-in-missing-month-year-with-previous-session-data/m-p/293576#M108927 <HTML><HEAD></HEAD><BODY><P>Hi Anita,</P><P></P><P>Maybe I'm not get your point. But let try this <A _jive_internal="true" href="https://community.qlik.com/message/171737#171737">http://community.qlik.com/message/171737#171737</A></P><P></P><P>Regards,</P><P>Sokkorn Cheav</P></BODY></HTML> Mon, 12 Dec 2011 12:27:12 GMT https://community.qlik.com/t5/QlikView/Fill-in-missing-month-year-with-previous-session-data/m-p/293576#M108927 Sokkorn 2011-12-12T12:27:12Z