Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Does Qlikview convert logical values before displaying them?

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?

1 Reply
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:

logicmark
142
14
134
124
02234

Please see the attached file for qv .

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.