topic Re: qvw file not able to retrive Boolean type values in QlikView

qvw file not able to retrive Boolean type values

jagannalla — Thu, 23 Aug 2012 15:19:13 GMT

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.

Re: qvw file not able to retrive Boolean type values

chematos — Thu, 23 Aug 2012 15:35:43 GMT

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

fabs(num#(Field1)) ??

Re: qvw file not able to retrive Boolean type values

erichshiino — Thu, 23 Aug 2012 16:12:20 GMT

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

Re: qvw file not able to retrive Boolean type values

jagannalla — Tue, 28 Aug 2012 09:31:35 GMT

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;