topic handling -ve values in QlikView https://community.qlik.com/t5/QlikView/handling-ve-values/m-p/144057#M23127 <HTML><HEAD></HEAD><BODY><P>may be <B>TextBetween(<I>fieldname</I>,'(',')')</B> can help you.</P></BODY></HTML> Thu, 14 May 2009 01:36:56 GMT yblake 2009-05-14T01:36:56Z handling -ve values https://community.qlik.com/t5/QlikView/handling-ve-values/m-p/144056#M23126 <HTML><HEAD></HEAD><BODY><P>The -ve values of a field when read , are being converted in this format , (123345) (i.e. encapsulated by brackets). So are excluded in aggregations.</P><P>How to load the fields having -ve values.?</P><P>Any help is appreciated.</P><P>Thanks.</P><P></P></BODY></HTML> Thu, 14 May 2009 01:31:22 GMT https://community.qlik.com/t5/QlikView/handling-ve-values/m-p/144056#M23126 2009-05-14T01:31:22Z handling -ve values https://community.qlik.com/t5/QlikView/handling-ve-values/m-p/144057#M23127 <HTML><HEAD></HEAD><BODY><P>may be <B>TextBetween(<I>fieldname</I>,'(',')')</B> can help you.</P></BODY></HTML> Thu, 14 May 2009 01:36:56 GMT https://community.qlik.com/t5/QlikView/handling-ve-values/m-p/144057#M23127 yblake 2009-05-14T01:36:56Z handling -ve values https://community.qlik.com/t5/QlikView/handling-ve-values/m-p/144058#M23128 <HTML><HEAD></HEAD><BODY><P>I figured it out.Issue was with the file.The Cell which holds these values has no format.I changed it to 'General'.</P><P>Thanks.</P></BODY></HTML> Thu, 14 May 2009 01:39:43 GMT https://community.qlik.com/t5/QlikView/handling-ve-values/m-p/144058#M23128 2009-05-14T01:39:43Z