qlikview changes true/1 value to -1

[#1]

Hi,

I am loading some permission values as 1 or 0. However, when I view that data in Qlikview, the 1 has become -1 every where while zero remained zero

Can someone please explain what is the reason behind this and how to fix this

Arif

[jpenuliar]

try fabs() to reverse the sign.

[jpenuliar · Accepted solution]

I've encountered same question:

Re: 1 is displayed as -1

[#4]

Thanks for the reply. That would indeed resolve it but I am still trying to understand why is Qlikview changing it into -1

Arif

[jpenuliar]

see if the link i sent you earlier explained it.

base on that, i am convinced it is "By Design" feature.

I suppose Qlik support will be best to confirm that.

JP