topic Slight Help in QlikView https://community.qlik.com/t5/QlikView/Slight-Help/m-p/699047#M673268 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I need some help.</P><P></P><P>As you can see in attached file, I have some chart and I dont know what to do.</P><P></P><P>As you can see, there are multiple locations that I use as a dimension, to get the size of application that each location uses.</P><P></P><P>On the bottom are application, that are not used still, and I want to show how much each location is using space without the bottom -.</P><P></P><P>I cannot suppress the values, because it will only remove the info from the chart.</P><P></P><P></P><P>I am using the variable to sum everything, and then I divide the size of Qvw in MB with it.</P></BODY></HTML> Mon, 18 Aug 2014 18:22:19 GMT 2014-08-18T18:22:19Z Slight Help https://community.qlik.com/t5/QlikView/Slight-Help/m-p/699047#M673268 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I need some help.</P><P></P><P>As you can see in attached file, I have some chart and I dont know what to do.</P><P></P><P>As you can see, there are multiple locations that I use as a dimension, to get the size of application that each location uses.</P><P></P><P>On the bottom are application, that are not used still, and I want to show how much each location is using space without the bottom -.</P><P></P><P>I cannot suppress the values, because it will only remove the info from the chart.</P><P></P><P></P><P>I am using the variable to sum everything, and then I divide the size of Qvw in MB with it.</P></BODY></HTML> Mon, 18 Aug 2014 18:22:19 GMT https://community.qlik.com/t5/QlikView/Slight-Help/m-p/699047#M673268 2014-08-18T18:22:19Z Re: Slight Help https://community.qlik.com/t5/QlikView/Slight-Help/m-p/699048#M673269 <HTML><HEAD></HEAD><BODY><P>You can check the dimension for NULL values with the ISNULL function.&nbsp;&nbsp; IE:&nbsp;&nbsp; isnull(Location)&lt;&gt;-1&nbsp;&nbsp; checks for only non-null values. Use it in the numerator and denonomitor to get a share that excludes the applications without a location</P></BODY></HTML> Mon, 18 Aug 2014 18:30:01 GMT https://community.qlik.com/t5/QlikView/Slight-Help/m-p/699048#M673269 JonnyPoole 2014-08-18T18:30:01Z