topic Re: Qlikview weird behaviour in QlikView

Qlikview weird behaviour

Fri, 20 Nov 2020 18:02:30 GMT

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 ?

Re: Qlikview weird behaviour

ashfaq_haseeb — Mon, 04 Aug 2014 09:01:20 GMT

Hi,

try with text(yourfield) as Field.

Regards

ASHFAQ

Re: Qlikview weird behaviour

jonathandienst — Mon, 04 Aug 2014 09:02:51 GMT

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

Re: Qlikview weird behaviour

Anonymous — Mon, 04 Aug 2014 09:08:14 GMT

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

Re: Qlikview weird behaviour

Mon, 04 Aug 2014 10:12:58 GMT

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

but it won't fully resolve my problem.

Re: Qlikview weird behaviour

ashfaq_haseeb — Mon, 04 Aug 2014 10:29:38 GMT

Hi,

Can you post sample application.

Regards

ASHFAQ

Re: Qlikview weird behaviour

Mon, 04 Aug 2014 10:34:07 GMT

Hi Jakub,

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

Re: Qlikview weird behaviour

Mon, 04 Aug 2014 10:51:43 GMT

nope, both solutions num# and num doesnt work 😕

Re: Qlikview weird behaviour

Mon, 04 Aug 2014 10:56:56 GMT

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

Re: Qlikview weird behaviour

ashfaq_haseeb — Mon, 04 Aug 2014 11:03:39 GMT

Hi try below

num(floor(Yourfield)) as Field

Regards

ASHFAQ

Re: Qlikview weird behaviour

Mon, 04 Aug 2014 11:07:33 GMT

This is bit strange. From which database you pulling the data? Secondly are you saving this into a qvd and then applying the QV functions or in extraction load.

Re: Qlikview weird behaviour

Mon, 04 Aug 2014 11:07:58 GMT

Well, i figured out that this wasn't 100 but smth like 99.99999999 ...