topic Re: how to cast -1 to 1 while loading from Database in QlikView https://community.qlik.com/t5/QlikView/how-to-cast-1-to-1-while-loading-from-Database/m-p/395330#M147431 <HTML><HEAD></HEAD><BODY><P>this is not a QV behaviour, but you can use fabs(field) to have absolute value so -1 will become 1</P></BODY></HTML> Fri, 01 Feb 2013 20:55:12 GMT alexandros17 2013-02-01T20:55:12Z how to cast -1 to 1 while loading from Database https://community.qlik.com/t5/QlikView/how-to-cast-1-to-1-while-loading-from-Database/m-p/395329#M147430 <HTML><HEAD></HEAD><BODY><P>I have a strange issue, I have a field in my sql database which holds values 1 and 0 but when I load into QV its showing me -1 and 0 how should I change to 1 and 0...Thanks</P></BODY></HTML> Fri, 01 Feb 2013 20:53:32 GMT https://community.qlik.com/t5/QlikView/how-to-cast-1-to-1-while-loading-from-Database/m-p/395329#M147430 2013-02-01T20:53:32Z Re: how to cast -1 to 1 while loading from Database https://community.qlik.com/t5/QlikView/how-to-cast-1-to-1-while-loading-from-Database/m-p/395330#M147431 <HTML><HEAD></HEAD><BODY><P>this is not a QV behaviour, but you can use fabs(field) to have absolute value so -1 will become 1</P></BODY></HTML> Fri, 01 Feb 2013 20:55:12 GMT https://community.qlik.com/t5/QlikView/how-to-cast-1-to-1-while-loading-from-Database/m-p/395330#M147431 alexandros17 2013-02-01T20:55:12Z Re: how to cast -1 to 1 while loading from Database https://community.qlik.com/t5/QlikView/how-to-cast-1-to-1-while-loading-from-Database/m-p/395331#M147432 <HTML><HEAD></HEAD><BODY><P>if(fieldname=-1,1,0) ?</P><P></P><P>By the way, boolean fields have -1 or 0 values, so it's not really strange.</P></BODY></HTML> Fri, 01 Feb 2013 20:56:01 GMT https://community.qlik.com/t5/QlikView/how-to-cast-1-to-1-while-loading-from-Database/m-p/395331#M147432 danielrozental 2013-02-01T20:56:01Z