topic Re: Exclude values in QlikView https://community.qlik.com/t5/QlikView/Exclude-values/m-p/367409#M703021 <HTML><HEAD></HEAD><BODY><P>Perfect, thank you Miguel!</P></BODY></HTML> Wed, 25 Jul 2012 14:22:27 GMT 2012-07-25T14:22:27Z Exclude values https://community.qlik.com/t5/QlikView/Exclude-values/m-p/367407#M703019 <HTML><HEAD></HEAD><BODY><P>I would like to exclude all values for a field that are a certain length.</P><P></P><P>The reason for this is because a user has entered a false value against an invoice of 4 billion odd.&nbsp; This has been invoiced and then credited in our ERP system, but still shows in QlikView and really screws up the legends on our charts.</P><P></P><P>I'm guessing the easiest way would be to just if the invoice value is more than 9 characters trim to null as we will be dealing with a + and - value.</P><P></P><P>Any advice would be greatly appreciated.</P></BODY></HTML> Wed, 25 Jul 2012 14:07:22 GMT https://community.qlik.com/t5/QlikView/Exclude-values/m-p/367407#M703019 2012-07-25T14:07:22Z Re: Exclude values https://community.qlik.com/t5/QlikView/Exclude-values/m-p/367408#M703020 <HTML><HEAD></HEAD><BODY><P>Hi Lewis,</P><P></P><P>You can check for the length of that field in the script, and set its value to 0, so when it's aggregated or summed in the script will return 0.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13432256755651708" jivemacro_uid="_13432256755651708"><P>LOAD ...</P><P>&nbsp;&nbsp;&nbsp;&nbsp; If(Len(InvoiceValue) &gt; 9, 0, InvoiceValue) AS InvoiceValue,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; If(Len(InvoiceValue) &gt; 9, 1) AS FlagIncorrectInvoiceValue,</P><P>...</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Wed, 25 Jul 2012 14:16:23 GMT https://community.qlik.com/t5/QlikView/Exclude-values/m-p/367408#M703020 Miguel_Angel_Baeyens 2012-07-25T14:16:23Z Re: Exclude values https://community.qlik.com/t5/QlikView/Exclude-values/m-p/367409#M703021 <HTML><HEAD></HEAD><BODY><P>Perfect, thank you Miguel!</P></BODY></HTML> Wed, 25 Jul 2012 14:22:27 GMT https://community.qlik.com/t5/QlikView/Exclude-values/m-p/367409#M703021 2012-07-25T14:22:27Z