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/589639#M1114466 <HTML><HEAD></HEAD><BODY><P>Try populating zero for july and uncheck Suppress zero values. The line chart will automatically get connected to zero for july month and you can visually find the difference. Line will not be upward, instead it will be like a V shape while crossing july alone.</P></BODY></HTML> Mon, 17 Feb 2014 09:24:59 GMT 2014-02-17T09:24:59Z 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