Losing values in varchar/ alphanumeric column

Sat, 25 Aug 2012 09:34:35 GMT

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

Re: Losing values in varchar/ alphanumeric column

Sun, 26 Aug 2012 17:57:50 GMT

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

topic Losing values in varchar/ alphanumeric column in QlikView

Losing values in varchar/ alphanumeric column

Re: Losing values in varchar/ alphanumeric column