topic Break/Hide Trend Line Chart when data is not available in QlikView https://community.qlik.com/t5/QlikView/Break-Hide-Trend-Line-Chart-when-data-is-not-available/m-p/164034#M36877 <HTML><HEAD></HEAD><BODY><P>I have monthly trend chart with complex expression. I need help in hiding the line in the chart when there is no data available. For example if I have following data...</P><P>------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</P><P>Month Sales</P><P>Jan 1002</P><P>Feb 3852</P><P>Mar 2087</P><P>Apr 5275</P><P>May NULL</P><P>Jun NULL</P><P>Jul 2582</P><P>Aug 1853</P><P>------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</P><P>Now I wanted to hide or break the line in the chart for May &amp; Jun as the data is not available. And I wanted to continue with the trend line from July. I hope this makes sense!</P><P></P><P>Thanks in advance.</P><P></P><P>Cheers - DV</P><P></P><P></P><P></P></BODY></HTML> Wed, 16 Mar 2011 12:41:45 GMT IAMDV 2011-03-16T12:41:45Z Break/Hide Trend Line Chart when data is not available https://community.qlik.com/t5/QlikView/Break-Hide-Trend-Line-Chart-when-data-is-not-available/m-p/164034#M36877 <HTML><HEAD></HEAD><BODY><P>I have monthly trend chart with complex expression. I need help in hiding the line in the chart when there is no data available. For example if I have following data...</P><P>------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</P><P>Month Sales</P><P>Jan 1002</P><P>Feb 3852</P><P>Mar 2087</P><P>Apr 5275</P><P>May NULL</P><P>Jun NULL</P><P>Jul 2582</P><P>Aug 1853</P><P>------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</P><P>Now I wanted to hide or break the line in the chart for May &amp; Jun as the data is not available. And I wanted to continue with the trend line from July. I hope this makes sense!</P><P></P><P>Thanks in advance.</P><P></P><P>Cheers - DV</P><P></P><P></P><P></P></BODY></HTML> Wed, 16 Mar 2011 12:41:45 GMT https://community.qlik.com/t5/QlikView/Break-Hide-Trend-Line-Chart-when-data-is-not-available/m-p/164034#M36877 IAMDV 2011-03-16T12:41:45Z