Data flags from SQL sever load as -1

[#1]

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.

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.

Any insight ?

[stephencredmond]

Hi,

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.

Stephen