Does Qlikview convert logical values before displaying them?

Tue, 30 Oct 2012 19:43:22 GMT

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?

Re: Does Qlikview convert logical values before displaying them?

MayilVahanan — Tue, 30 Oct 2012 20:23:33 GMT

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

topic Does Qlikview convert logical values before displaying them? in QlikView

Does Qlikview convert logical values before displaying them?

Re: Does Qlikview convert logical values before displaying them?