topic Re: Qlikview QVD File in QlikView

Qlikview QVD File

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Guys,

When I store '1' value in QVD format from the data source, it is stored as '-1' instead of '1'.Please anyone help why it is?

Re: Qlikview QVD File

Anil_Babu_Samineni — Thu, 20 Apr 2017 11:39:49 GMT

Please provide more information with sample data and store command

Re: Qlikview QVD File

kaushiknsolanki — Thu, 20 Apr 2017 11:40:14 GMT

HI,

what is the data source. Make sure you use the correct version of the connectors.

Regards,

Kaushik Solanki

Re: Qlikview QVD File

Peter_Cammaert — Thu, 20 Apr 2017 12:19:58 GMT

That may be due to the fact that systems sometimes treat 1-bit values as signed (meaning that if the bit is set, it actually corresponds to a negative value).

Are you able to find out whether the negative value is already present in your QlikView field? If that's the case, force a conversion to 0 or 1 on loading from your data source, and your export to QVD will be ok.

Re: Qlikview QVD File

stigchel — Thu, 20 Apr 2017 12:54:58 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 ....