https://community.qlik.com/t5/App-Development/Continue-line-in-line-chart-when-there-is-no-data/m-p/1922131#M75903 <P>Hi,</P> <P>I have a line chart where months are in x-axis and price is in y-axis. I don't have data for the full year.</P> <P>I have created the following structure If(price_this_month &gt; 0, price_this_month, variable_last_valid_price)</P> <P>variable_last_valid_price is price of the current month, because that is available.</P> <P>This works fine when I select one product and the line continues at this month level. However, the variable_last_valid_price sums together when there is two or more products.</P> <P>How to use a variable separately for each product or is there other ways to use the last available data in the line chart?</P> <P>&nbsp;</P> Mon, 25 Apr 2022 12:53:55 GMT Ax 2022-04-25T12:53:55Z https://community.qlik.com/t5/App-Development/Continue-line-in-line-chart-when-there-is-no-data/m-p/1922131#M75903 <P>Hi,</P> <P>I have a line chart where months are in x-axis and price is in y-axis. I don't have data for the full year.</P> <P>I have created the following structure If(price_this_month &gt; 0, price_this_month, variable_last_valid_price)</P> <P>variable_last_valid_price is price of the current month, because that is available.</P> <P>This works fine when I select one product and the line continues at this month level. However, the variable_last_valid_price sums together when there is two or more products.</P> <P>How to use a variable separately for each product or is there other ways to use the last available data in the line chart?</P> <P>&nbsp;</P> Mon, 25 Apr 2022 12:53:55 GMT https://community.qlik.com/t5/App-Development/Continue-line-in-line-chart-when-there-is-no-data/m-p/1922131#M75903 Ax 2022-04-25T12:53:55Z