Does Qlikview convert logical values before displaying them?

[#1]

We have a SQL database that contains a logical field. When I import that field into QV, it displays as either "-1" or "0". However, when I viewed it in the native SQL format, it was "1" or "0". Does QV convert SQL's default logical values to its own values (i.e. the number displayed, not true  or false) when it imports the table?

[MayilVahanan]

Hi

As per my test, i can see 1 and 0 for true n false in qv. for bit values..

ODBC CONNECT TO TestPurpose;

LOAD logic,

    mark;

SQL SELECT logic,

    mark

FROM Northwind.dbo.TEST;

Sql:

create table test(logic bit, mark int);

insert into test values('true',42);

insert into test values('true',4);

insert into test values('true',34);

insert into test values('true',24);

insert into test values('false',2234);

Select * from test;

Test table o/p:

logic	mark
1	42
1	4
1	34
1	24
0	2234

Please see the attached file for qv .

Hope it helps