topic Re: Positive values are converted to negative values in QlikView

Positive values are converted to negative values

spsrk_84 — Thu, 19 Oct 2017 12:37:07 GMT

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

Re: Positive values are converted to negative values

techvarun — Thu, 19 Oct 2017 12:53:20 GMT

The below thread may help you

SQL select iterprets 1 as -1

Re: Positive values are converted to negative values

pradosh_thakur — Thu, 19 Oct 2017 13:10:34 GMT

if it gets solved then well and good else you ca use fabs() to convert it to positive number.

regards

Pradosh

Re: Positive values are converted to negative values

stigchel — Thu, 19 Oct 2017 13:13:30 GMT

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 ....

Re: Positive values are converted to negative values

spsrk_84 — Fri, 20 Oct 2017 07:34:31 GMT

Column data type is bit thus i am getting the values 1 as -1 values.

Thank you stigchel