topic Re: 1 is displayed as -1 in QlikView https://community.qlik.com/t5/QlikView/1-is-displayed-as-1/m-p/401733#M149491 <HTML><HEAD></HEAD><BODY><P>Boolean data type in SQL has 1 for TRUE, 0 for FLASE.</P><P></P><P>In Qlikview, -1 is TRUE and 0 is FALSE.</P><P></P><P>Is the column, that you are handling, having Boolean data type? </P></BODY></HTML> Mon, 04 Mar 2013 06:01:19 GMT nagaiank 2013-03-04T06:01:19Z 1 is displayed as -1 https://community.qlik.com/t5/QlikView/1-is-displayed-as-1/m-p/401732#M149490 <HTML><HEAD></HEAD><BODY><P> I am using Qlikview version 11. In the database,the specific column has value as 1. When i load the data in to Qlikview the data is showing as -1. Any got the similar problem. Is it the know issue or any settings got changed?</P><P></P><P><SPAN style="font-size: 10pt;"> </SPAN></P></BODY></HTML> Mon, 04 Mar 2013 05:42:56 GMT https://community.qlik.com/t5/QlikView/1-is-displayed-as-1/m-p/401732#M149490 brindlogcool 2013-03-04T05:42:56Z Re: 1 is displayed as -1 https://community.qlik.com/t5/QlikView/1-is-displayed-as-1/m-p/401733#M149491 <HTML><HEAD></HEAD><BODY><P>Boolean data type in SQL has 1 for TRUE, 0 for FLASE.</P><P></P><P>In Qlikview, -1 is TRUE and 0 is FALSE.</P><P></P><P>Is the column, that you are handling, having Boolean data type? </P></BODY></HTML> Mon, 04 Mar 2013 06:01:19 GMT https://community.qlik.com/t5/QlikView/1-is-displayed-as-1/m-p/401733#M149491 nagaiank 2013-03-04T06:01:19Z Re: 1 is displayed as -1 https://community.qlik.com/t5/QlikView/1-is-displayed-as-1/m-p/401734#M149492 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-IN" style="font-family: 'Arial','sans-serif'; font-size: 10pt;">if we want to remove the –ve symbol then we have to use the expression:</SPAN></P><P><SPAN lang="EN-IN" style="font-family: 'Arial','sans-serif'; font-size: 10pt;"> </SPAN></P><UL><LI><EM><SPAN lang="EN" style="font-family: 'Arial','sans-serif'; font-size: 9pt;">num(Expression,'#,##0.00;(#,##0.00)')</SPAN></EM></LI></UL><P style="padding-left: 22.5px;"><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> </SPAN></P><P><STRONG><EM>Syntax:</EM></STRONG></P><P><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> </SPAN></P><P><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">Num (sum</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;"> (</SPAN><SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Field1</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">) – </SPAN><SPAN style="font-family: 'Courier New'; color: blue; font-size: 9pt;">sum (<SPAN style="font-family: 'Courier New'; color: maroon; font-size: 9pt;">Field2</SPAN></SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 9pt;">), ‘#,##0.00;(#,##0.00)’)</SPAN></P></BODY></HTML> Mon, 04 Mar 2013 06:20:10 GMT https://community.qlik.com/t5/QlikView/1-is-displayed-as-1/m-p/401734#M149492 2013-03-04T06:20:10Z