topic Re: Remove spaces with in Clustered bars in Chart in QlikView https://community.qlik.com/t5/QlikView/Remove-spaces-with-in-Clustered-bars-in-Chart/m-p/858419#M300679 <HTML><HEAD></HEAD><BODY><P>I don't think there is a way to remove them. What I usually do is use this as my expression:</P><P></P><P><STRONG>=If(Len(Trim(yourExpression)) = 0, 0.0000001, yourExpression)</STRONG></P><P></P><P>This forces a slight bar (removing the extra space) and when you put value on the chart it shows you 0 on top of it.</P><P></P><P>It's just a work around I have used lately, but I would be curious to know if there is a way to remove the extra space.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 17 Apr 2015 20:01:39 GMT sunny_talwar 2015-04-17T20:01:39Z Remove spaces with in Clustered bars in Chart https://community.qlik.com/t5/QlikView/Remove-spaces-with-in-Clustered-bars-in-Chart/m-p/858418#M300678 <HTML><HEAD></HEAD><BODY><P>How to remove spaces with clustered bars in a bar chart.when I select the cluster (Dimension value)I dont see any spaces but without any selection I see gaps.See below.I tried bar cluster distance and bar distance and supressing nulls also.No luck</P><P></P><P>&nbsp;&nbsp; <IMG alt="cap1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/84002_cap1.JPG" style="height: auto;" /><IMG alt="cap 2.JPG" class="jive-image image-2" src="/legacyfs/online/84003_cap 2.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 17 Apr 2015 19:55:21 GMT https://community.qlik.com/t5/QlikView/Remove-spaces-with-in-Clustered-bars-in-Chart/m-p/858418#M300678 chaper 2015-04-17T19:55:21Z Re: Remove spaces with in Clustered bars in Chart https://community.qlik.com/t5/QlikView/Remove-spaces-with-in-Clustered-bars-in-Chart/m-p/858419#M300679 <HTML><HEAD></HEAD><BODY><P>I don't think there is a way to remove them. What I usually do is use this as my expression:</P><P></P><P><STRONG>=If(Len(Trim(yourExpression)) = 0, 0.0000001, yourExpression)</STRONG></P><P></P><P>This forces a slight bar (removing the extra space) and when you put value on the chart it shows you 0 on top of it.</P><P></P><P>It's just a work around I have used lately, but I would be curious to know if there is a way to remove the extra space.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 17 Apr 2015 20:01:39 GMT https://community.qlik.com/t5/QlikView/Remove-spaces-with-in-Clustered-bars-in-Chart/m-p/858419#M300679 sunny_talwar 2015-04-17T20:01:39Z Re: Remove spaces with in Clustered bars in Chart https://community.qlik.com/t5/QlikView/Remove-spaces-with-in-Clustered-bars-in-Chart/m-p/858420#M300680 <HTML><HEAD></HEAD><BODY><P>Tried your expression.No luck</P><P></P><P>Thanks</P></BODY></HTML> Fri, 17 Apr 2015 20:17:09 GMT https://community.qlik.com/t5/QlikView/Remove-spaces-with-in-Clustered-bars-in-Chart/m-p/858420#M300680 chaper 2015-04-17T20:17:09Z Re: Remove spaces with in Clustered bars in Chart https://community.qlik.com/t5/QlikView/Remove-spaces-with-in-Clustered-bars-in-Chart/m-p/858421#M300681 <HTML><HEAD></HEAD><BODY><P>Well like I said, it won't remove the empty space, it will just show a very small bar. It is not showing a very small bar? Can you share a screenshot of what it showed after you added the suggested expression?</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 17 Apr 2015 20:19:05 GMT https://community.qlik.com/t5/QlikView/Remove-spaces-with-in-Clustered-bars-in-Chart/m-p/858421#M300681 sunny_talwar 2015-04-17T20:19:05Z