Qlikview Interpreting "1" as "-1"

[#1]

Hi,

I am loading some data from sql into a QVD.

For the Active column its showing : 1

In the QVD data is stored as -1.

Please help

[tresesco]

Without going into the cause analysis, can suggest a work around. Try loading multiplying it with -1, like:

Load

          Active*(-1) as Active

[#3]

Yeah i am using the same method as suggested by you.

But just wanted to know why  this is  happening?

[tabisen1]

Poornima,

Please try the fabs function fabs(Active) to get the -1 to 1.

[#5]

TRY THIS

FABS(ACTIVE)

[tresesco]

I have not faced such issue so far, so it would be hard for me to help without being on the actual platform. May be somebody faced the issue could help you answer 'why?'.

[iktrayanov]

Probably your Active in SQL is type Bit which is interpreted as TRUE in QlikView hence -1

Regards,

Ivan

[#8]

HI

TRY THIS IN Active  FIELD

Text(Active)

[tresesco]

Hi Ivan,

Good point ! could be the actual reason.

[iktrayanov]

If that is the case cast(Active as char(1)) in the load should do the trick.