qvw file not able to retrive Boolean type values

[jagannalla]

Hi All,

I've a boolean column in my database. I generated qvd file for the data which i'm receving from sql. The boolean values in my sql is 0 and 1. But in my qvd i can able to see 0 and -1. So when i loading the qvd i'm using fabs(Field1) as Field1 in the script. But in field1 i can able to see only 0 value. What is the problem. Why qvw file not able to read boolean values.

[chematos]

I´m guessing but may be qlikview is not considering as numeric that values, what happens if you use

fabs(num#(Field1)) ??

[erichshiino]

Hi,

Your case is similar to this:

http://community.qlik.com/message/44507#44507

If I remember correctly this -1 will appear only on 64bit machines.

If fabs() returns an expected value, maybe you can use if( Field1 = 0 , 0 ,1 ) as Field1

Hope it helps,

Erich

[jagannalla · Accepted solution]

Sorry for the late reply. Yes, I'm using 64 bit. I did like this, While generating the qvd file i used Fabs for the field it works for me.

For eg:

Load *, Fabs(FieldName) as FieldName1;

SQL * From Table1;