https://community.qlik.com/t5/App-Development/Ignore-null-in-a-bar-chart-with-years-comparison/m-p/1596562#M44101 <P>Hi,</P><P>I have a demand to display a bar chart where every bar is showing the difference from the previous year.</P><P>sum({&lt;Date ={"&gt;=$(vYearStartPrev4)"}&gt;} SalesInvoice_Line_TotalPriceUSD)<BR />/<BR />Above(sum({&lt;Date ={"&gt;=$(vYearStartPrev3)"}&gt;} SalesInvoice_Line_TotalPriceUSD))-1</P><P><SPAN>I need to show data&nbsp; from 2016 only.&nbsp;</SPAN></P><P>How do I get rid of 2015?</P><P>&nbsp;</P><P>Thanks!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="YoY" style="width: 948px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14512iCAF476BDC2D9FB51/image-size/large?v=v2&amp;px=999" role="button" title="Year_Comparison.png" alt="YoY" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">YoY</span></span></P><P>&nbsp;</P> Sat, 16 Nov 2024 20:34:18 GMT Dafna 2024-11-16T20:34:18Z https://community.qlik.com/t5/App-Development/Ignore-null-in-a-bar-chart-with-years-comparison/m-p/1596562#M44101 <P>Hi,</P><P>I have a demand to display a bar chart where every bar is showing the difference from the previous year.</P><P>sum({&lt;Date ={"&gt;=$(vYearStartPrev4)"}&gt;} SalesInvoice_Line_TotalPriceUSD)<BR />/<BR />Above(sum({&lt;Date ={"&gt;=$(vYearStartPrev3)"}&gt;} SalesInvoice_Line_TotalPriceUSD))-1</P><P><SPAN>I need to show data&nbsp; from 2016 only.&nbsp;</SPAN></P><P>How do I get rid of 2015?</P><P>&nbsp;</P><P>Thanks!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="YoY" style="width: 948px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14512iCAF476BDC2D9FB51/image-size/large?v=v2&amp;px=999" role="button" title="Year_Comparison.png" alt="YoY" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">YoY</span></span></P><P>&nbsp;</P> Sat, 16 Nov 2024 20:34:18 GMT https://community.qlik.com/t5/App-Development/Ignore-null-in-a-bar-chart-with-years-comparison/m-p/1596562#M44101 Dafna 2024-11-16T20:34:18Z https://community.qlik.com/t5/App-Development/Ignore-null-in-a-bar-chart-with-years-comparison/m-p/1596692#M44109 <P>The solution is to uncheck the&nbsp; <STRONG>Include zero option</STRONG> in the <STRONG>Add-ons</STRONG> tab.</P> Thu, 27 Jun 2019 10:25:49 GMT https://community.qlik.com/t5/App-Development/Ignore-null-in-a-bar-chart-with-years-comparison/m-p/1596692#M44109 Dafna 2019-06-27T10:25:49Z