topic Problem loading record in QlikView

Problem loading record

Anonymous — Mon, 29 Jun 2009 22:50:00 GMT

Hi, i have a strange problem loading a table like this :

CODICE
10.507.1
15.207.1

when i put the fields CODICE on a sheet , i can only see the first value, the same happens changing the order of the data.

The other strange things is that the count of the record loaded return 2 !

Obviosly this data is just a part of a bigger table (23353 row)

Thank's

Luca C.

Problem loading record

Mon, 29 Jun 2009 23:39:18 GMT

One reason I know of that can cause this, is if QlikView thinks the two values are the same, it would then look like only one value once loaded. Perhaps the periods are fooling it. Try putting the value in single quotes.

Problem loading record

Anonymous — Tue, 30 Jun 2009 00:10:37 GMT

Thank you Eugene,

for sure the periods cause the problem, unfortunatly this is the product code that my customer uses from many years.

I tryed the quote solution but without success.

The problem disappear if a put a character before the first number i.e.

A10.507.1

or if i replace the '.' with '_'.

but if i choose this solution i have to recode all table linked with the product table.

Sigh !

Problem loading record

rwunderlich — Tue, 30 Jun 2009 01:00:49 GMT

Try using the text() function when loading the field.

-Rob

Problem loading record

Anonymous — Tue, 30 Jun 2009 13:40:09 GMT

Great!

Thank's Rob, it works fine !.

I've to modify the script but this is nothing compare to recode all the product.

Bye