Discussion Board for collaboration related to QlikView App Development.
I was testing optimization by cut big number in two numbers with less values when an error occur.
Memory didn't decrease as I thought but increased because of Frac() function.
Frac() function returns more precision numbers than the reference field.
Here is my script :
round(100*rand(),0.01) as val
floor(val) as floor,
Frac(val) as frac
drop table TEST_TEMP;
And here is the result :
I had test on QV 11.2012018.0 SR3 and 11.2012018.0 SR5.
So I've to do this : round(Frac(val),0.01)
Has someone have the same result in others Qv versions ?
I think it's not a bug :
View solution in original post