Bit value of 1 read as -1

[tvisha]

Hi,

I have a field that is bit, in SQL with values as 1 and 0. When I pull in Qlik it reads as -1 and 0.

Does qlik interpret it that way?

Rains

[MarcoWedel · Accepted solution]

Yes it does:

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Operators/Lo...