topic Re: Fill missing months with data in QlikView https://community.qlik.com/t5/QlikView/Fill-missing-months-with-data/m-p/1807229#M1212222 <P>I found solution in&nbsp;<A title="Generating Missing Data In QlikView" href="https://community.qlik.com/t5/Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394" target="_blank" rel="noopener">Generating Missing Data In QlikView</A>&nbsp;post by&nbsp;Henric_Cronström</P> Wed, 12 May 2021 09:32:30 GMT JoeWhite 2021-05-12T09:32:30Z Fill missing months with data https://community.qlik.com/t5/QlikView/Fill-missing-months-with-data/m-p/1803845#M1211933 <P>Hello, everyone.</P><P>I'd like to insert missing months for each Product_ID in table below.</P><TABLE border="1"><TBODY><TR><TD>Product_ID</TD><TD>State</TD><TD>Country</TD><TD>Date</TD></TR><TR><TD>1</TD><TD>Added</TD><TD>Spain</TD><TD>01.12.2020</TD></TR><TR><TD>1</TD><TD>Modified</TD><TD>Germany</TD><TD>01.02.2021</TD></TR><TR><TD>1</TD><TD>Deleted</TD><TD>Germany</TD><TD>01.04.2021</TD></TR><TR><TD>2</TD><TD>Added</TD><TD>Spain</TD><TD>01.02.2021</TD></TR></TBODY></TABLE><P>I want to see at which dates product stayed in a country. E.g. Product 1 stayed in Spain since 01.12.2020 till 01.02.2021</P><P>Products have 3 states. And if it's not deleted then I want to extend it to <EM>monthstart(today()).</EM></P><P>Expected result: (added rows colored blue)</P><TABLE border="1"><TBODY><TR><TD>Product_ID</TD><TD>Country</TD><TD>Date</TD></TR><TR><TD>1</TD><TD>Spain</TD><TD>01.12.2020</TD></TR><TR><TD><FONT color="#00CCFF">1</FONT></TD><TD><FONT color="#00CCFF">Spain</FONT></TD><TD><FONT color="#00CCFF">01.01.2021</FONT></TD></TR><TR><TD>1</TD><TD>Germany</TD><TD>01.02.2021</TD></TR><TR><TD><FONT color="#00CCFF">1</FONT></TD><TD><FONT color="#00CCFF">Germany</FONT></TD><TD><FONT color="#00CCFF">01.03.2021</FONT></TD></TR><TR><TD>1</TD><TD>Germany</TD><TD>01.04.2021</TD></TR><TR><TD>2</TD><TD>Spain</TD><TD>01.02.2021</TD></TR><TR><TD><FONT color="#00CCFF">2</FONT></TD><TD><FONT color="#00CCFF">Spain</FONT></TD><TD><FONT color="#00CCFF">01.03.2021</FONT></TD></TR><TR><TD><FONT color="#00CCFF">2</FONT></TD><TD><FONT color="#00CCFF">Spain</FONT></TD><TD><FONT color="#00CCFF">01.04.2021</FONT></TD></TR></TBODY></TABLE><P>Thanks for help.</P> Thu, 29 Apr 2021 14:04:17 GMT https://community.qlik.com/t5/QlikView/Fill-missing-months-with-data/m-p/1803845#M1211933 JoeWhite 2021-04-29T14:04:17Z Re: Fill missing months with data https://community.qlik.com/t5/QlikView/Fill-missing-months-with-data/m-p/1803846#M1211934 <P>Forgot to mention that I want to achieve this in load script.</P> Thu, 29 Apr 2021 14:06:51 GMT https://community.qlik.com/t5/QlikView/Fill-missing-months-with-data/m-p/1803846#M1211934 JoeWhite 2021-04-29T14:06:51Z Re: Fill missing months with data https://community.qlik.com/t5/QlikView/Fill-missing-months-with-data/m-p/1806263#M1212118 <P>So, is it not possible to do such thing in Qlik?</P> Fri, 07 May 2021 17:38:49 GMT https://community.qlik.com/t5/QlikView/Fill-missing-months-with-data/m-p/1806263#M1212118 JoeWhite 2021-05-07T17:38:49Z Re: Fill missing months with data https://community.qlik.com/t5/QlikView/Fill-missing-months-with-data/m-p/1807229#M1212222 <P>I found solution in&nbsp;<A title="Generating Missing Data In QlikView" href="https://community.qlik.com/t5/Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394" target="_blank" rel="noopener">Generating Missing Data In QlikView</A>&nbsp;post by&nbsp;Henric_Cronström</P> Wed, 12 May 2021 09:32:30 GMT https://community.qlik.com/t5/QlikView/Fill-missing-months-with-data/m-p/1807229#M1212222 JoeWhite 2021-05-12T09:32:30Z