num(num#(Value)) returns incorrect results for certain Value range

[swuehl]

A strange behaviour in combining num with num# function for certain numerical values was observed here:

http://community.qlik.com/message/152786

Reproduced with  QV 10.00.9061.7 SR3

See attached sample.

num(num#(Value)) fails to return correct results for values in the range pow(2,31) and pow(2, 33).

[s_uhlig]

Hi,

really strange - to get more confused, try num(num#(column(1),'#')), which works over the whole range on QV9, but gives up at 2^47 on QV10 !???

BTW, 1e300/-1e300 are singular values too.

Thanks for sharing

Sven

PS.: try to format column(1) as number

[swuehl]

Just stumbled upon this old thread.

Seems not to be present in QV11.20 SR11 anymore.