1 is displayed as -1

[brindlogcool]

I am using Qlikview version 11. In the database,the specific column has value as 1. When i load the data in to Qlikview the data is showing as -1. Any got the similar problem. Is it the know issue or any settings got changed?

[nagaiank · Accepted solution]

Boolean data type in SQL has 1 for TRUE, 0 for FLASE.

In Qlikview, -1 is TRUE and 0 is FALSE.

Is the column, that you are handling, having Boolean data type?

[#3]

if we want to remove the –ve symbol then we have to use the expression:

• num(Expression,'#,##0.00;(#,##0.00)')

Syntax:

Num (sum (Field1) – sum (Field2), ‘#,##0.00;(#,##0.00)’)