topic Re: Break Line chart in QlikView https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821875#M1045794 <HTML><HEAD></HEAD><BODY><P>I don't think from script it will work. Bcz Sales1 has txn for 23-11-2014, so we can't remove nulls here.</P><P></P><P>Regards,</P><P>Navdeep</P></BODY></HTML> Wed, 26 Nov 2014 11:17:39 GMT 2014-11-26T11:17:39Z Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821866#M1045785 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>Is there any method in qlikview to break time series line chart on basis of data points.</P><P></P><P>Like I want my line chart to break if data is not present on some particular data point.</P><P></P><P>Regards,</P><P>Navdeep</P></BODY></HTML> Wed, 26 Nov 2014 09:06:54 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821866#M1045785 2014-11-26T09:06:54Z Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821867#M1045786 <HTML><HEAD></HEAD><BODY><P>Try in the properties of the Chart object -&gt; Dimensions -&gt; Suppress When Values is Null.</P></BODY></HTML> Wed, 26 Nov 2014 09:30:06 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821867#M1045786 qlikconsultant 2014-11-26T09:30:06Z Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821868#M1045787 <HTML><HEAD></HEAD><BODY><P>post some sample application or images for desired output</P></BODY></HTML> Wed, 26 Nov 2014 09:38:56 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821868#M1045787 2014-11-26T09:38:56Z Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821869#M1045788 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Please find attached the demo app. I want Sale 2 to break on 23-11-2014 and again starts for other dates.</P><P></P><P>Regards,</P><P>Navdeep&nbsp; </P></BODY></HTML> Wed, 26 Nov 2014 09:54:28 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821869#M1045788 2014-11-26T09:54:28Z Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821870#M1045789 <HTML><HEAD></HEAD><BODY><P>Hi Markus,</P><P></P><P>I tried suppress, but it didn't work. Please check the demo app attached.</P></BODY></HTML> Wed, 26 Nov 2014 09:56:32 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821870#M1045789 2014-11-26T09:56:32Z Re: Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821871#M1045790 <HTML><HEAD></HEAD><BODY><P>Hope this help you</P></BODY></HTML> Wed, 26 Nov 2014 10:30:29 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821871#M1045790 2014-11-26T10:30:29Z Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821872#M1045791 <HTML><HEAD></HEAD><BODY><P>I would recommend to use Dots or a Bar instead. If you use the solution from Bhawna Gupta you need for every null or 0 value a new expression. With Bar or Dots it works fine.</P></BODY></HTML> Wed, 26 Nov 2014 10:40:45 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821872#M1045791 qlikconsultant 2014-11-26T10:40:45Z Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821873#M1045792 <HTML><HEAD></HEAD><BODY><P>Hi Bhawna,</P><P></P><P>Thnks for the time. But in my case, I have a huge data set and m not sure on which date data would be missing. Is there any dynamic way to acheive this? </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Navdeep </SPAN></P></BODY></HTML> Wed, 26 Nov 2014 10:41:13 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821873#M1045792 2014-11-26T10:41:13Z Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821874#M1045793 <HTML><HEAD></HEAD><BODY><P>Sure thre is a way, you just do it in the script with an if(isnull(),0,...)</P></BODY></HTML> Wed, 26 Nov 2014 10:54:59 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821874#M1045793 2014-11-26T10:54:59Z Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821875#M1045794 <HTML><HEAD></HEAD><BODY><P>I don't think from script it will work. Bcz Sales1 has txn for 23-11-2014, so we can't remove nulls here.</P><P></P><P>Regards,</P><P>Navdeep</P></BODY></HTML> Wed, 26 Nov 2014 11:17:39 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821875#M1045794 2014-11-26T11:17:39Z Re: Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821876#M1045795 <HTML><HEAD></HEAD><BODY><P>sales1 and Sales2 are two different fields, so using the if bellow ! works even for chaging the color of the line.</P></BODY></HTML> Wed, 26 Nov 2014 13:33:47 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821876#M1045795 2014-11-26T13:33:47Z Re: Break Line chart https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821877#M1045796 <HTML><HEAD></HEAD><BODY><P>Hey navdeep,</P><P></P><P>Not quite exactly what you wanted, but it might be pretty close. What I did was</P><UL><LI>use the above function on the expression to create a second point after the last one that has a value on the line, so in this case the line doesn't drop to 0</LI><LI>use the argb() function to color the sections of the line that have value and hide the parts of the line without value</LI></UL><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95441_Capture.PNG" style="height: 505px; width: 620px;" /></P></BODY></HTML> Sun, 09 Aug 2015 01:47:09 GMT https://community.qlik.com/t5/QlikView/Break-Line-chart/m-p/821877#M1045796 Renato_Vieira 2015-08-09T01:47:09Z