Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a DB2 db, a column value is '123456789' and another is ' 123456789' where a space in the front. The qv always return me both the same value even i converted to text, replace function also can't detect the "space". How to get the value not to trim?
Thanks.
I found the solution. set Verbatim=1, explanation from help "Normally all field values are automatically stripped of preceding and succeeding blank characters (ASCII 32) before being loaded into the QlikView database. Setting this variable to 1 suspends the stripping of blank characters."
Next you need to convert the value to string to preserve the space.