Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi
Check the decimal point. It might be 99.9 which is showing you 100.
Hi,
try with text(yourfield) as Field.
Regards
ASHFAQ
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
Hi
Check the decimal point. It might be 99.9 which is showing you 100.
text(field)=100 and num(field) also return 100, with 2 decimal it show 100,00
but it won't fully resolve my problem.
Hi,
Can you post sample application.
Regards
ASHFAQ
Hi Jakub,
It might be in text , try num#(Field). If its not working try num(num#(Field)).
nope, both solutions num# and num doesnt work 😕
I used num(100, '(bin)') and it of course return 1100100, but my magical field return 1100011,1111111111
Hi try below
num(floor(Yourfield)) as Field
Regards
ASHFAQ