topic YoY Growth, data from previous year in App Development https://community.qlik.com/t5/App-Development/YoY-Growth-data-from-previous-year/m-p/1602303#M44584 <P>Hello Experts,&nbsp;</P><P>I'm in dire need of your assistance with the following issue.</P><P>I want to retrieve data from a table to fetch values from previous years and determine the growth YoY.</P><P>As of now, the table looks like this:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Year</TD><TD>Region</TD><TD>Make</TD><TD>Model</TD><TD>Sales</TD></TR><TR><TD>2020</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1000</TD></TR><TR><TD>2020</TD><TD>Japan</TD><TD>Nissan</TD><TD>Altima</TD><TD>1500</TD></TR><TR><TD>2020</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>800</TD></TR><TR><TD>2021</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1100</TD></TR><TR><TD>2021</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1600</TD></TR><TR><TD>2021</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>900</TD></TR><TR><TD>2022</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1200</TD></TR><TR><TD>2022</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1700</TD></TR><TR><TD>2022</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1000</TD></TR><TR><TD>2023</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1300</TD></TR><TR><TD>2023</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1800</TD></TR><TR><TD>2023</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1100</TD></TR><TR><TD>2024</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1400</TD></TR><TR><TD>2024</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1900</TD></TR><TR><TD>2024</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1200</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need the result to be something along the lines of the following table:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Year</TD><TD>Region</TD><TD>Make</TD><TD>Model</TD><TD>Sales</TD><TD><STRONG>Last Year Sales</STRONG></TD></TR><TR><TD>2020</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1000</TD><TD>&nbsp;</TD></TR><TR><TD>2020</TD><TD>Japan</TD><TD>Nissan</TD><TD>Altima</TD><TD>1500</TD><TD>&nbsp;</TD></TR><TR><TD>2020</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>800</TD><TD>&nbsp;</TD></TR><TR><TD>2021</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1100</TD><TD><STRONG>1000</STRONG></TD></TR><TR><TD>2021</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1600</TD><TD><STRONG>1500</STRONG></TD></TR><TR><TD>2021</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>900</TD><TD><STRONG>800</STRONG></TD></TR><TR><TD>2022</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1200</TD><TD><STRONG>1100</STRONG></TD></TR><TR><TD>2022</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1700</TD><TD><STRONG>1600</STRONG></TD></TR><TR><TD>2022</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1000</TD><TD><STRONG>900</STRONG></TD></TR><TR><TD>2023</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1300</TD><TD><STRONG>1200</STRONG></TD></TR><TR><TD>2023</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1800</TD><TD><STRONG>1700</STRONG></TD></TR><TR><TD>2023</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1100</TD><TD><STRONG>1000</STRONG></TD></TR><TR><TD>2024</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1400</TD><TD><STRONG>1300</STRONG></TD></TR><TR><TD>2024</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1900</TD><TD><STRONG>1800</STRONG></TD></TR><TR><TD>2024</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1200</TD><TD><STRONG>1100</STRONG></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I've tried using Above(), and offset the number of rows to get the correct value for each year, however, once I apply filters, the values are incorrect.</P><P>The end result would be a line chart, showing YoY growth, that can be filtered by region, make or model.</P><P>Thank you!</P> Mon, 15 Jul 2019 12:19:34 GMT Joakimnn 2019-07-15T12:19:34Z YoY Growth, data from previous year https://community.qlik.com/t5/App-Development/YoY-Growth-data-from-previous-year/m-p/1602303#M44584 <P>Hello Experts,&nbsp;</P><P>I'm in dire need of your assistance with the following issue.</P><P>I want to retrieve data from a table to fetch values from previous years and determine the growth YoY.</P><P>As of now, the table looks like this:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Year</TD><TD>Region</TD><TD>Make</TD><TD>Model</TD><TD>Sales</TD></TR><TR><TD>2020</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1000</TD></TR><TR><TD>2020</TD><TD>Japan</TD><TD>Nissan</TD><TD>Altima</TD><TD>1500</TD></TR><TR><TD>2020</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>800</TD></TR><TR><TD>2021</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1100</TD></TR><TR><TD>2021</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1600</TD></TR><TR><TD>2021</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>900</TD></TR><TR><TD>2022</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1200</TD></TR><TR><TD>2022</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1700</TD></TR><TR><TD>2022</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1000</TD></TR><TR><TD>2023</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1300</TD></TR><TR><TD>2023</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1800</TD></TR><TR><TD>2023</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1100</TD></TR><TR><TD>2024</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1400</TD></TR><TR><TD>2024</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1900</TD></TR><TR><TD>2024</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1200</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need the result to be something along the lines of the following table:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Year</TD><TD>Region</TD><TD>Make</TD><TD>Model</TD><TD>Sales</TD><TD><STRONG>Last Year Sales</STRONG></TD></TR><TR><TD>2020</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1000</TD><TD>&nbsp;</TD></TR><TR><TD>2020</TD><TD>Japan</TD><TD>Nissan</TD><TD>Altima</TD><TD>1500</TD><TD>&nbsp;</TD></TR><TR><TD>2020</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>800</TD><TD>&nbsp;</TD></TR><TR><TD>2021</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1100</TD><TD><STRONG>1000</STRONG></TD></TR><TR><TD>2021</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1600</TD><TD><STRONG>1500</STRONG></TD></TR><TR><TD>2021</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>900</TD><TD><STRONG>800</STRONG></TD></TR><TR><TD>2022</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1200</TD><TD><STRONG>1100</STRONG></TD></TR><TR><TD>2022</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1700</TD><TD><STRONG>1600</STRONG></TD></TR><TR><TD>2022</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1000</TD><TD><STRONG>900</STRONG></TD></TR><TR><TD>2023</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1300</TD><TD><STRONG>1200</STRONG></TD></TR><TR><TD>2023</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1800</TD><TD><STRONG>1700</STRONG></TD></TR><TR><TD>2023</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1100</TD><TD><STRONG>1000</STRONG></TD></TR><TR><TD>2024</TD><TD>North America</TD><TD>Ford</TD><TD>Fiesta</TD><TD>1400</TD><TD><STRONG>1300</STRONG></TD></TR><TR><TD>2024</TD><TD>China</TD><TD>Nissan</TD><TD>Altima</TD><TD>1900</TD><TD><STRONG>1800</STRONG></TD></TR><TR><TD>2024</TD><TD>Europe</TD><TD>Hyundai</TD><TD>Elantra</TD><TD>1200</TD><TD><STRONG>1100</STRONG></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I've tried using Above(), and offset the number of rows to get the correct value for each year, however, once I apply filters, the values are incorrect.</P><P>The end result would be a line chart, showing YoY growth, that can be filtered by region, make or model.</P><P>Thank you!</P> Mon, 15 Jul 2019 12:19:34 GMT https://community.qlik.com/t5/App-Development/YoY-Growth-data-from-previous-year/m-p/1602303#M44584 Joakimnn 2019-07-15T12:19:34Z Re: YoY Growth, data from previous year https://community.qlik.com/t5/App-Development/YoY-Growth-data-from-previous-year/m-p/1602624#M44607 <P>Hi Joakimnn,</P><P>What you need to do is the following:</P><LI-CODE lang="markup">Table: Load Year &amp;'|'&amp; Region &amp;'|'&amp; Make &amp;'|'&amp; Model as %Table Year, Region, Make, Model, Sales From [YourSource] (qvd); Left Join (Table) Load (Year+1) &amp;'|'&amp; Region &amp;'|'&amp; Make &amp;'|'&amp; Model as %Table Sales From [YourSource] (qvd);</LI-CODE><P>&nbsp;</P><P>Now you have joined your sales to the table.</P><P>Second option is to go for a mapping load and return 0 if there is no sales for the previous year. In the first solution you will get a null().</P><P>Jordy</P><P>Climber</P> Tue, 16 Jul 2019 09:31:45 GMT https://community.qlik.com/t5/App-Development/YoY-Growth-data-from-previous-year/m-p/1602624#M44607 JordyWegman 2019-07-16T09:31:45Z