topic Re: Empty Spaces - Teradata in QlikView https://community.qlik.com/t5/QlikView/Empty-Spaces-Teradata/m-p/1260719#M397689 <HTML><HEAD></HEAD><BODY><P>Apparently just copy and pasting the empty space out of teradata worked:</P><P></P><P>IF(ContractPUOMCode = 'EA' AND ContractLIUOMCode = 'EA' AND (PriceChargeUOMCode = 'EA' OR PriceChargeUOMCode = '&nbsp; '), 'Yes','No') AS EAIND,</P></BODY></HTML> Wed, 22 Mar 2017 16:33:46 GMT NickHoff 2017-03-22T16:33:46Z Empty Spaces - Teradata https://community.qlik.com/t5/QlikView/Empty-Spaces-Teradata/m-p/1260718#M397688 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a field that is not a true NULL, but it includes an empty space in the data set.&nbsp; However, i'm trying to create an indicator which includes the empty space, but I can't get it to work correctly using the following.&nbsp; Any ideas?</P><P></P><P>IF(ContractPUOMCode = 'EA' AND ContractLIUOMCode = 'EA' AND (PriceChargeUOMCode = 'EA' OR ISNULL(PriceChargeUOMCode)= -1 OR PriceChargeUOMCode = '' OR PriceChargeUOMCode = ' '), 'Yes','No')</P></BODY></HTML> Wed, 22 Mar 2017 14:35:45 GMT https://community.qlik.com/t5/QlikView/Empty-Spaces-Teradata/m-p/1260718#M397688 NickHoff 2017-03-22T14:35:45Z Re: Empty Spaces - Teradata https://community.qlik.com/t5/QlikView/Empty-Spaces-Teradata/m-p/1260719#M397689 <HTML><HEAD></HEAD><BODY><P>Apparently just copy and pasting the empty space out of teradata worked:</P><P></P><P>IF(ContractPUOMCode = 'EA' AND ContractLIUOMCode = 'EA' AND (PriceChargeUOMCode = 'EA' OR PriceChargeUOMCode = '&nbsp; '), 'Yes','No') AS EAIND,</P></BODY></HTML> Wed, 22 Mar 2017 16:33:46 GMT https://community.qlik.com/t5/QlikView/Empty-Spaces-Teradata/m-p/1260719#M397689 NickHoff 2017-03-22T16:33:46Z