- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Positive values are converted to negative values
Hi All,
I am facing quite strange issue while loading data from SQL database into Qlikview version 12.10.0.0 i.e. i am loading data from a table and the table has columns such as Reporting,Deliver,Admin and all these fields has values 0 & 1 only in the table. But when loaded into qlikview all the 1's are replaced with -1 which is quite unexpected.
i tried the approaches such uninstalling qlikiview & installing again, qliksense was also their in my and i uninstalled it.
verified to load the same data values from excel file and they are loading absolutely fine.
If anyone has come across this kind of issue please do let me know how to resolve this issue.
Thanks,
Shivarama krishna K
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You are probably loading from a sql table where a field is defined as bit and is returned as true/false. QlikView stores true() as -1. You can converse this like below (2 ways)
SQL SELECT [ID],
case
when BitField= 1 then 1
when BitField= 0 then 0
end AS SomeColumn
,Cast(BitField as Int) as SomeColumn2
FROM ....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The below thread may help you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
if it gets solved then well and good else you ca use fabs() to convert it to positive number.
regards
Pradosh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You are probably loading from a sql table where a field is defined as bit and is returned as true/false. QlikView stores true() as -1. You can converse this like below (2 ways)
SQL SELECT [ID],
case
when BitField= 1 then 1
when BitField= 0 then 0
end AS SomeColumn
,Cast(BitField as Int) as SomeColumn2
FROM ....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Column data type is bit thus i am getting the values 1 as -1 values.
Thank you stigchel