topic Re: Help with chat in QlikView https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714975#M672512 <HTML><HEAD></HEAD><BODY><P>Supress values where Location is Null?</P></BODY></HTML> Wed, 20 Aug 2014 13:55:09 GMT ThornOfCrowns 2014-08-20T13:55:09Z Help with chat https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714974#M672511 <HTML><HEAD></HEAD><BODY><P>Hello all, I have attached the picture, that explains what needs to be done.</P><P></P><P>I have no idea how to do it.</P><P></P><P>Thank you for any input</P></BODY></HTML> Wed, 20 Aug 2014 13:49:52 GMT https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714974#M672511 2014-08-20T13:49:52Z Re: Help with chat https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714975#M672512 <HTML><HEAD></HEAD><BODY><P>Supress values where Location is Null?</P></BODY></HTML> Wed, 20 Aug 2014 13:55:09 GMT https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714975#M672512 ThornOfCrowns 2014-08-20T13:55:09Z Re: Re: Help with chat https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714976#M672513 <HTML><HEAD></HEAD><BODY><P>When I suppress i get this</P></BODY></HTML> Wed, 20 Aug 2014 13:58:27 GMT https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714976#M672513 2014-08-20T13:58:27Z Re: Help with chat https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714977#M672514 <HTML><HEAD></HEAD><BODY><P>When you bring in the data you can use a where clause where Len(Trim(Location)) &gt; 0 which will filter out the blanks.</P></BODY></HTML> Wed, 20 Aug 2014 13:59:02 GMT https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714977#M672514 jpapador 2014-08-20T13:59:02Z Re: Help with chat https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714978#M672515 <HTML><HEAD></HEAD><BODY><P>check out the attachment.</P><P></P><P>for future reference, please read through this page<A href="https://community.qlik.com/docs/DOC-2380">QlikCommunity Tip: How to get answers to your post?</A></P></BODY></HTML> Wed, 20 Aug 2014 14:04:10 GMT https://community.qlik.com/t5/QlikView/Help-with-chat/m-p/714978#M672515 Anonymous 2014-08-20T14:04:10Z