topic Re: Problem with Line Charts and Bar charts! in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589620#M1114444 <HTML><HEAD></HEAD><BODY><P>Im getting the information from a OBDC SQL server, so i dont see how i can do that <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 14 Feb 2014 14:33:19 GMT 2014-02-14T14:33:19Z Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589613#M1114425 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I think i have a wierd problem! When i use Bar chart you can see that the Yellow does not have values for Feb -&gt; Jul and that is right. But in the Line chart the yellow line does have values over these month which is incorrect.</P><P></P><P>Thanksfull for help!</P><P></P><P><IMG alt="1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/53216_1.JPG.jpg" style="width: 620px; height: 236px;" /><IMG alt="2.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/53217_2.JPG.jpg" /></P></BODY></HTML> Fri, 14 Feb 2014 14:24:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589613#M1114425 2014-02-14T14:24:04Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589614#M1114428 <HTML><HEAD></HEAD><BODY><P>Try unchecking continuous in axis tab.</P><P>-Sundar</P></BODY></HTML> Fri, 14 Feb 2014 14:27:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589614#M1114428 sundarakumar 2014-02-14T14:27:04Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589615#M1114433 <HTML><HEAD></HEAD><BODY><P>Hi Erik,</P><P></P><P>that's just because, in a line chart, the data_points get connected automatically - a line is actually nothing else than dots (over the dimension_points) which are automatically connected.</P><P>=&gt; A solution might be to somehow modify your formula so that, when there is no value, a 0 gets populated - that way, the line would plunge to 0 after Jan and go back up only in August.</P><P>HTH</P><P></P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Fri, 14 Feb 2014 14:27:24 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589615#M1114433 datanibbler 2014-02-14T14:27:24Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589616#M1114436 <HTML><HEAD></HEAD><BODY><P>It is already unchecked.</P></BODY></HTML> Fri, 14 Feb 2014 14:28:58 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589616#M1114436 2014-02-14T14:28:58Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589617#M1114439 <HTML><HEAD></HEAD><BODY><P>I see, do you have any solution? I want exactly what you are explaining, that the line dips down to zero when there is no value!</P></BODY></HTML> Fri, 14 Feb 2014 14:29:54 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589617#M1114439 2014-02-14T14:29:54Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589618#M1114440 <HTML><HEAD></HEAD><BODY><P>in presentatioon uncheck "suppress zero value"</P><P></P><P>hope it helps</P></BODY></HTML> Fri, 14 Feb 2014 14:30:56 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589618#M1114440 alexandros17 2014-02-14T14:30:56Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589619#M1114442 <HTML><HEAD></HEAD><BODY><P>fill in the missing data points with zero value..</P></BODY></HTML> Fri, 14 Feb 2014 14:31:14 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589619#M1114442 rbecher 2014-02-14T14:31:14Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589620#M1114444 <HTML><HEAD></HEAD><BODY><P>Im getting the information from a OBDC SQL server, so i dont see how i can do that <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 14 Feb 2014 14:33:19 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589620#M1114444 2014-02-14T14:33:19Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589621#M1114446 <HTML><HEAD></HEAD><BODY><P>Nope <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P></BODY></HTML> Fri, 14 Feb 2014 14:34:32 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589621#M1114446 2014-02-14T14:34:32Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589622#M1114449 <HTML><HEAD></HEAD><BODY><P>Btw. you can show additional dots on the line to marke the data points..</P></BODY></HTML> Fri, 14 Feb 2014 14:36:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589622#M1114449 rbecher 2014-02-14T14:36:04Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589623#M1114450 <HTML><HEAD></HEAD><BODY><P>Since im a newbie regarding Qlikview, please tell me how to!</P></BODY></HTML> Fri, 14 Feb 2014 14:39:57 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589623#M1114450 2014-02-14T14:39:57Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589624#M1114451 <HTML><HEAD></HEAD><BODY><P>Can't see how that should help sorry.. Still i want the yellow line to show zeros since there is no data there!</P><P><IMG alt="3.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/53219_3.JPG.jpg" /></P></BODY></HTML> Fri, 14 Feb 2014 14:43:43 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589624#M1114451 2014-02-14T14:43:43Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589625#M1114452 <HTML><HEAD></HEAD><BODY><P>At least you can see that there are no data points.</P></BODY></HTML> Fri, 14 Feb 2014 14:45:53 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589625#M1114452 rbecher 2014-02-14T14:45:53Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589626#M1114453 <HTML><HEAD></HEAD><BODY><P>Yes, but still it is very confussing for people looking at the graph...</P><P></P><P>There must be a solution to this problem?</P></BODY></HTML> Fri, 14 Feb 2014 14:47:59 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589626#M1114453 2014-02-14T14:47:59Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589627#M1114454 <HTML><HEAD></HEAD><BODY><P>Could you post an example. Maybe you can use Aggr() or a 2nd dimension..</P></BODY></HTML> Fri, 14 Feb 2014 14:50:53 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589627#M1114454 rbecher 2014-02-14T14:50:53Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589628#M1114455 <HTML><HEAD></HEAD><BODY><P>What's your expression? If it's a simple sum, you could try something like:</P><P></P><P>=if( IsNull (sum( field ) ) ), 0, sum( Field ) )</P><P></P><P>That should put a zero everywhere there is no value.</P></BODY></HTML> Fri, 14 Feb 2014 14:54:15 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589628#M1114455 2014-02-14T14:54:15Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589629#M1114456 <HTML><HEAD></HEAD><BODY><P>NumericCount (date_from)</P><P></P><P>Is my expression.</P></BODY></HTML> Fri, 14 Feb 2014 14:55:52 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589629#M1114456 2014-02-14T14:55:52Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589630#M1114457 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Try Like Below:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">IF(IsNull(NumericCount (date_from)) , 0 , NumericCount (date_from))</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Uncheck the Supress zero values in the Presenation tab</P></BODY></HTML> Fri, 14 Feb 2014 14:59:16 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589630#M1114457 2014-02-14T14:59:16Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589631#M1114458 <HTML><HEAD></HEAD><BODY><P>Yep, this should do it.</P></BODY></HTML> Fri, 14 Feb 2014 15:03:28 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589631#M1114458 2014-02-14T15:03:28Z Re: Problem with Line Charts and Bar charts! https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589632#M1114459 <HTML><HEAD></HEAD><BODY><P>I have unchecked the Supress Zero, and used your expression.</P><P></P><P>Is does not work <span class="lia-unicode-emoji" title=":confused_face:">😕</span> Still the yellow line is there.</P></BODY></HTML> Fri, 14 Feb 2014 15:10:36 GMT https://community.qlik.com/t5/QlikView/Problem-with-Line-Charts-and-Bar-charts/m-p/589632#M1114459 2014-02-14T15:10:36Z