topic Re: How to leave the missing value as a gap in Combo Chart? in App Development https://community.qlik.com/t5/App-Development/How-to-leave-the-missing-value-as-a-gap-in-Combo-Chart/m-p/112987#M7795 <HTML><HEAD></HEAD><BODY><P>Maybe one of these:</P><P></P><P>Add-ons &gt; Data handling &gt; Include zero values (deselect)</P><P></P><P>or</P><P></P><P>IF(Measure &gt; 0, Measure)</P></BODY></HTML> Wed, 17 Oct 2018 16:39:30 GMT Ivan_Bozov 2018-10-17T16:39:30Z How to leave the missing value as a gap in Combo Chart? https://community.qlik.com/t5/App-Development/How-to-leave-the-missing-value-as-a-gap-in-Combo-Chart/m-p/112986#M7794 <HTML><HEAD></HEAD><BODY><P>Could someone help me to figure out on remove those drop lines in a combo chart?</P><P>I tried the chart option to leave the missing value as a gap, but it didn't work.</P><P>Thank you in advance.</P><P><IMG alt="HelpQlik.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/216140_HelpQlik.PNG" style="width: 620px; height: 264px;" /></P></BODY></HTML> Wed, 17 Oct 2018 16:30:46 GMT https://community.qlik.com/t5/App-Development/How-to-leave-the-missing-value-as-a-gap-in-Combo-Chart/m-p/112986#M7794 isaaclin 2018-10-17T16:30:46Z Re: How to leave the missing value as a gap in Combo Chart? https://community.qlik.com/t5/App-Development/How-to-leave-the-missing-value-as-a-gap-in-Combo-Chart/m-p/112987#M7795 <HTML><HEAD></HEAD><BODY><P>Maybe one of these:</P><P></P><P>Add-ons &gt; Data handling &gt; Include zero values (deselect)</P><P></P><P>or</P><P></P><P>IF(Measure &gt; 0, Measure)</P></BODY></HTML> Wed, 17 Oct 2018 16:39:30 GMT https://community.qlik.com/t5/App-Development/How-to-leave-the-missing-value-as-a-gap-in-Combo-Chart/m-p/112987#M7795 Ivan_Bozov 2018-10-17T16:39:30Z Re: How to leave the missing value as a gap in Combo Chart? https://community.qlik.com/t5/App-Development/How-to-leave-the-missing-value-as-a-gap-in-Combo-Chart/m-p/112988#M7796 <HTML><HEAD></HEAD><BODY><P>Thank you Ivan for the quick response and the correct answer.</P><P></P><P>the option 2 works for me for my case, but I believe the option 1 could work, if I convert the null into 0 in my load script.</P><P></P><P>Thanks again.</P><P></P><P>Isaac</P></BODY></HTML> Wed, 17 Oct 2018 16:54:42 GMT https://community.qlik.com/t5/App-Development/How-to-leave-the-missing-value-as-a-gap-in-Combo-Chart/m-p/112988#M7796 isaaclin 2018-10-17T16:54:42Z Re: How to leave the missing value as a gap in Combo Chart? https://community.qlik.com/t5/App-Development/How-to-leave-the-missing-value-as-a-gap-in-Combo-Chart/m-p/112989#M7797 <HTML><HEAD></HEAD><BODY><P>Glad it works. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 17 Oct 2018 17:17:04 GMT https://community.qlik.com/t5/App-Development/How-to-leave-the-missing-value-as-a-gap-in-Combo-Chart/m-p/112989#M7797 Ivan_Bozov 2018-10-17T17:17:04Z