topic Hide Trend Line in QlikView https://community.qlik.com/t5/QlikView/Hide-Trend-Line/m-p/164327#M37065 <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></BODY></HTML> Wed, 16 Mar 2011 14:24:25 GMT IAMDV 2011-03-16T14:24:25Z Hide Trend Line https://community.qlik.com/t5/QlikView/Hide-Trend-Line/m-p/164327#M37065 <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></BODY></HTML> Wed, 16 Mar 2011 14:24:25 GMT https://community.qlik.com/t5/QlikView/Hide-Trend-Line/m-p/164327#M37065 IAMDV 2011-03-16T14:24:25Z Hide Trend Line https://community.qlik.com/t5/QlikView/Hide-Trend-Line/m-p/164328#M37066 <HTML><HEAD></HEAD><BODY><P>Attached QVW. Best answer I know of. All instructions in text box in QVW.</P></BODY></HTML> Wed, 16 Mar 2011 15:31:55 GMT https://community.qlik.com/t5/QlikView/Hide-Trend-Line/m-p/164328#M37066 2011-03-16T15:31:55Z Hide Trend Line https://community.qlik.com/t5/QlikView/Hide-Trend-Line/m-p/164329#M37067 <HTML><HEAD></HEAD><BODY><P>Awesome! Thanks so much...</P></BODY></HTML> Wed, 16 Mar 2011 16:50:52 GMT https://community.qlik.com/t5/QlikView/Hide-Trend-Line/m-p/164329#M37067 IAMDV 2011-03-16T16:50:52Z