Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
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?
if we want to remove the –ve symbol then we have to use the expression:
Syntax:
Num (sum (Field1) – sum (Field2), ‘#,##0.00;(#,##0.00)’)