Losing values in varchar/ alphanumeric column

[#1]

Hello

I have a strange behaviour:

Products-Table in MS-SQLServer 2008 R2:

ProductNr (varchar)          ProductDesc (varchar)

250190                             Product1

250.190                            Product2

Problem: Qlikview Desktop 11 loses one of that value. So that only the line 250190 remains in the Table.

Info: I've tried text(ProductNr) for the column. Also i did casts or str function in SQL to definitely get string values into QV.

Has anyone got a similar experience?

Regards

Oliver

[#2]

Hi Oliver,

I got similar experiences. Qlikview "optimizes" incoming values. (In my oppinion this is a bug)

The funny thing is, it does not only reduce blanks, but it takes the first value with blanks as the "correct one", but at least you have two records. It's hard to explain,see my example - app.

And as you can also see, the text() - function works as expected.

HtH

Roland