topic Inline Load in QlikView

topic Inline Load in QlikView https://community.qlik.com/t5/QlikView/Inline-Load/m-p/2016828#M1221932 <P>Hi team, </P> <P>I am getting sales data every year, Example Shown in below table, every year last data updated in data base.</P> <P>I am using 2 tier architecture , first one for Extraction and second one final Application.</P> <P>How to write incremental load in this case</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="25%" height="25px">Product</TD> <TD width="25%" height="25px">Year</TD> <TD width="25%" height="25px">Month</TD> <TD width="25%" height="25px">Sales</TD> </TR> <TR> <TD width="25%" height="25px">Pen</TD> <TD width="25%" height="25px"><FONT color="#FF0000">2019</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF0000">DEC</FONT></TD> <TD width="25%" height="25px">100</TD> </TR> <TR> <TD width="25%" height="25px">Eraser</TD> <TD width="25%" height="25px"><FONT color="#FF0000">2019</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF0000">DEC</FONT></TD> <TD width="25%" height="25px">420</TD> </TR> <TR> <TD width="25%" height="25px">Pencil</TD> <TD width="25%" height="25px"><FONT color="#FF0000">2019</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF0000">DEC</FONT></TD> <TD width="25%" height="25px">580</TD> </TR> <TR> <TD width="25%" height="25px">Pen</TD> <TD width="25%" height="25px"><FONT color="#800080">2020</FONT></TD> <TD width="25%" height="25px"><FONT color="#800080">DEC</FONT></TD> <TD width="25%" height="25px">100</TD> </TR> <TR> <TD width="25%" height="25px">Eraser</TD> <TD width="25%" height="25px"><FONT color="#800080">2020</FONT></TD> <TD width="25%" height="25px"><FONT color="#800080">DEC</FONT></TD> <TD width="25%" height="25px">420</TD> </TR> <TR> <TD width="25%" height="25px">Pencil</TD> <TD width="25%" height="25px"><FONT color="#800080">2020</FONT></TD> <TD width="25%" height="25px"><FONT color="#800080">DEC</FONT></TD> <TD width="25%" height="25px">580</TD> </TR> <TR> <TD width="25%" height="25px">Pen</TD> <TD width="25%" height="25px"><FONT color="#FF6600">2021</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF6600">DEC</FONT></TD> <TD width="25%" height="25px">100</TD> </TR> <TR> <TD width="25%" height="25px">Eraser</TD> <TD width="25%" height="25px"><FONT color="#FF6600">2021</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF6600">DEC</FONT></TD> <TD width="25%" height="25px">420</TD> </TR> <TR> <TD width="25%" height="25px">Pencil</TD> <TD width="25%" height="25px"><FONT color="#FF6600">2021</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF6600">DEC</FONT></TD> <TD width="25%" height="25px">580</TD> </TR> </TBODY> </TABLE> Thu, 15 Dec 2022 05:54:10 GMT kmmqlick 2022-12-15T05:54:10Z Inline Load https://community.qlik.com/t5/QlikView/Inline-Load/m-p/2016828#M1221932 <P>Hi team, </P> <P>I am getting sales data every year, Example Shown in below table, every year last data updated in data base.</P> <P>I am using 2 tier architecture , first one for Extraction and second one final Application.</P> <P>How to write incremental load in this case</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="25%" height="25px">Product</TD> <TD width="25%" height="25px">Year</TD> <TD width="25%" height="25px">Month</TD> <TD width="25%" height="25px">Sales</TD> </TR> <TR> <TD width="25%" height="25px">Pen</TD> <TD width="25%" height="25px"><FONT color="#FF0000">2019</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF0000">DEC</FONT></TD> <TD width="25%" height="25px">100</TD> </TR> <TR> <TD width="25%" height="25px">Eraser</TD> <TD width="25%" height="25px"><FONT color="#FF0000">2019</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF0000">DEC</FONT></TD> <TD width="25%" height="25px">420</TD> </TR> <TR> <TD width="25%" height="25px">Pencil</TD> <TD width="25%" height="25px"><FONT color="#FF0000">2019</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF0000">DEC</FONT></TD> <TD width="25%" height="25px">580</TD> </TR> <TR> <TD width="25%" height="25px">Pen</TD> <TD width="25%" height="25px"><FONT color="#800080">2020</FONT></TD> <TD width="25%" height="25px"><FONT color="#800080">DEC</FONT></TD> <TD width="25%" height="25px">100</TD> </TR> <TR> <TD width="25%" height="25px">Eraser</TD> <TD width="25%" height="25px"><FONT color="#800080">2020</FONT></TD> <TD width="25%" height="25px"><FONT color="#800080">DEC</FONT></TD> <TD width="25%" height="25px">420</TD> </TR> <TR> <TD width="25%" height="25px">Pencil</TD> <TD width="25%" height="25px"><FONT color="#800080">2020</FONT></TD> <TD width="25%" height="25px"><FONT color="#800080">DEC</FONT></TD> <TD width="25%" height="25px">580</TD> </TR> <TR> <TD width="25%" height="25px">Pen</TD> <TD width="25%" height="25px"><FONT color="#FF6600">2021</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF6600">DEC</FONT></TD> <TD width="25%" height="25px">100</TD> </TR> <TR> <TD width="25%" height="25px">Eraser</TD> <TD width="25%" height="25px"><FONT color="#FF6600">2021</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF6600">DEC</FONT></TD> <TD width="25%" height="25px">420</TD> </TR> <TR> <TD width="25%" height="25px">Pencil</TD> <TD width="25%" height="25px"><FONT color="#FF6600">2021</FONT></TD> <TD width="25%" height="25px"><FONT color="#FF6600">DEC</FONT></TD> <TD width="25%" height="25px">580</TD> </TR> </TBODY> </TABLE> Thu, 15 Dec 2022 05:54:10 GMT https://community.qlik.com/t5/QlikView/Inline-Load/m-p/2016828#M1221932 kmmqlick 2022-12-15T05:54:10Z