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.
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.
