Qlikview weird behaviour

[#1]

Hi, in my case i'm connected to a database and download some data, one of the field is an simple numeric value. When qlikview just show me the value of this field it says '100',

len(trim(field)) = 3, it's ok until now :
len(trim(floor(field)))=2

and bitcount(field)=4 - it should return 3

moreover if(field=100, 'TRUE', 'FALSE') return false ...

How is this possible ? Problem with encoding ?

[ashfaq_haseeb]

Hi,

try with text(yourfield) as Field.

Regards

ASHFAQ

[jonathandienst]

Hi

Looks like that field has a dual value with a text representation of 100, but an underlying value of some other number. Try the expressions

     =num(field)

     =text(field)

in 2 list boxes to explore this further.

HTH

Jonathan

[Anonymous · Accepted solution]

Hi

Check the decimal point. It might be 99.9 which is showing you 100.

[#5]

text(field)=100 and num(field) also return 100, with 2 decimal it show 100,00

but it won't fully resolve my problem.

[ashfaq_haseeb]

Hi,

Can you post sample application.

Regards

ASHFAQ

[#7]

Hi Jakub,

It might be in text , try num#(Field). If its not working try num(num#(Field)).

[#8]

nope, both solutions num# and num doesnt work 😕

[#9]

I used num(100, '(bin)') and it of course return 1100100, but my magical field return 1100011,1111111111 

[ashfaq_haseeb]

Hi try below

num(floor(Yourfield)) as Field

Regards

ASHFAQ