topic Data flags from SQL sever load as -1 in QlikView https://community.qlik.com/t5/QlikView/Data-flags-from-SQL-sever-load-as-1/m-p/151257#M29150 <HTML><HEAD></HEAD><BODY><P>I was wondering if anyone has seen this happening. I am loading data from a sql server 2008 database. There are multiple "flag" fileds for example canclled order. The filed has 1 and 0 as values, when we pull the data into qlikview we are getting -1 and 0.</P><P>Easy enough, we build our expressions to use -1 but when we reload the same application on our production machine the values load as 1 and 0, breaking all of the expressions.</P><P></P><P>Any insight ?</P></BODY></HTML> Thu, 06 Aug 2009 19:48:36 GMT 2009-08-06T19:48:36Z Data flags from SQL sever load as -1 https://community.qlik.com/t5/QlikView/Data-flags-from-SQL-sever-load-as-1/m-p/151257#M29150 <HTML><HEAD></HEAD><BODY><P>I was wondering if anyone has seen this happening. I am loading data from a sql server 2008 database. There are multiple "flag" fileds for example canclled order. The filed has 1 and 0 as values, when we pull the data into qlikview we are getting -1 and 0.</P><P>Easy enough, we build our expressions to use -1 but when we reload the same application on our production machine the values load as 1 and 0, breaking all of the expressions.</P><P></P><P>Any insight ?</P></BODY></HTML> Thu, 06 Aug 2009 19:48:36 GMT https://community.qlik.com/t5/QlikView/Data-flags-from-SQL-sever-load-as-1/m-p/151257#M29150 2009-08-06T19:48:36Z Data flags from SQL sever load as -1 https://community.qlik.com/t5/QlikView/Data-flags-from-SQL-sever-load-as-1/m-p/151258#M29151 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I haven't seen that problem but you could try using the FAbs function in your load script and then you can be sure that the number will always be positive.</P><P></P><P>Stephen</P><P></P></BODY></HTML> Thu, 06 Aug 2009 19:52:44 GMT https://community.qlik.com/t5/QlikView/Data-flags-from-SQL-sever-load-as-1/m-p/151258#M29151 stephencredmond 2009-08-06T19:52:44Z