topic Data from bit field showing as -1 in QlikView https://community.qlik.com/t5/QlikView/Data-from-bit-field-showing-as-1/m-p/381864#M142488 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have brought some data through from a bit field in a SQL Server database; the '1' values from the db are showing as '-1' in the table in the QV report.</P><P></P><P>I've tried changing the Number options for the field in the Table Box Properties but it makes no difference.</P><P></P><P>How do I 'mask' this data and make it show as 1?</P></BODY></HTML> Wed, 29 Aug 2012 13:46:35 GMT 2012-08-29T13:46:35Z Data from bit field showing as -1 https://community.qlik.com/t5/QlikView/Data-from-bit-field-showing-as-1/m-p/381864#M142488 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have brought some data through from a bit field in a SQL Server database; the '1' values from the db are showing as '-1' in the table in the QV report.</P><P></P><P>I've tried changing the Number options for the field in the Table Box Properties but it makes no difference.</P><P></P><P>How do I 'mask' this data and make it show as 1?</P></BODY></HTML> Wed, 29 Aug 2012 13:46:35 GMT https://community.qlik.com/t5/QlikView/Data-from-bit-field-showing-as-1/m-p/381864#M142488 2012-08-29T13:46:35Z Re: Data from bit field showing as -1 https://community.qlik.com/t5/QlikView/Data-from-bit-field-showing-as-1/m-p/381865#M142489 <HTML><HEAD></HEAD><BODY><P>In script:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; -Field as Field;</P><P></P><P>??</P></BODY></HTML> Wed, 29 Aug 2012 14:26:36 GMT https://community.qlik.com/t5/QlikView/Data-from-bit-field-showing-as-1/m-p/381865#M142489 m_woolf 2012-08-29T14:26:36Z