topic Re: Issue with Block chart top10 and Bottom10 values in QlikView https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106715#M366485 <HTML><HEAD></HEAD><BODY><P>even I use the above expression ,I am getting error Positive andnegative vaues in the chart</P></BODY></HTML> Wed, 01 Jun 2016 14:38:46 GMT mayankraoka 2016-06-01T14:38:46Z Issue with Block chart top10 and Bottom10 values https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106712#M366482 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I am trying to show top10 and bottom10 sales values of customer in block chart.I tried to limit the dimension by dimension limit tab and showing largest 10 for top 10 and smallest 10 for bottom 10.The issue here I am facing is getting the correct value for top10.But for bottom I am not getting any data.The reason I can see is in my data there are certain values with negative numbers.</P><P></P><P>Is there any way we can show bottom 10 values?</P><P></P><P>Please let me know in case of any questions.</P><P></P><P>Regards,</P><P>Mayank</P></BODY></HTML> Wed, 01 Jun 2016 14:14:42 GMT https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106712#M366482 mayankraoka 2016-06-01T14:14:42Z Re: Issue with Block chart top10 and Bottom10 values https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106713#M366483 <HTML><HEAD></HEAD><BODY><P>may be try with this expression instead of Dimension limit</P><P></P><P>=sum({&lt;BlockChartDimesion={"= rank(sum(Amount),4)&lt;=10"}&gt; +&lt;BlockChartDimesion={"= rank(-sum(Amount),4)&lt;=10"}&gt;}Amount)</P></BODY></HTML> Wed, 01 Jun 2016 14:23:00 GMT https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106713#M366483 Kushal_Chawda 2016-06-01T14:23:00Z Re: Issue with Block chart top10 and Bottom10 values https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106714#M366484 <HTML><HEAD></HEAD><BODY><P>They are 2 different charts 1 is for top 10 and 1 is for bottom 10.It will get enabled on button selection for top and botttom.</P></BODY></HTML> Wed, 01 Jun 2016 14:33:23 GMT https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106714#M366484 mayankraoka 2016-06-01T14:33:23Z Re: Issue with Block chart top10 and Bottom10 values https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106715#M366485 <HTML><HEAD></HEAD><BODY><P>even I use the above expression ,I am getting error Positive andnegative vaues in the chart</P></BODY></HTML> Wed, 01 Jun 2016 14:38:46 GMT https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106715#M366485 mayankraoka 2016-06-01T14:38:46Z Re: Issue with Block chart top10 and Bottom10 values https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106716#M366486 <HTML><HEAD></HEAD><BODY><P>can you post sample?</P></BODY></HTML> Wed, 01 Jun 2016 14:41:42 GMT https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106716#M366486 Kushal_Chawda 2016-06-01T14:41:42Z Re: Issue with Block chart top10 and Bottom10 values https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106717#M366487 <HTML><HEAD></HEAD><BODY><P>Hi Kushal,</P><P></P><P>Again back to the old issue.</P><P></P><P>Attached is the sample qvw.</P><P></P><P>Please let me know in case of any more information required.</P><P></P><P>Regards,</P><P>Mayank !</P></BODY></HTML> Thu, 13 Oct 2016 08:26:44 GMT https://community.qlik.com/t5/QlikView/Issue-with-Block-chart-top10-and-Bottom10-values/m-p/1106717#M366487 mayankraoka 2016-10-13T08:26:44Z