topic Re: Wrong format in QlikView

Wrong format

Mon, 04 Mar 2013 16:12:05 GMT

Hello,

I am trying to bring a field into QV but instead of bringing me the values, it transforms half of them into numbers(or date). Here is what I mean:

How can I keep the format on the left?

Thank you

Re: Wrong format

alexandros17 — Mon, 04 Mar 2013 16:18:31 GMT

Are you reading from xls file? can you provide it?

Re: Wrong format

Mon, 04 Mar 2013 16:28:58 GMT

I am reading the data from a .dbf file (fox). I cannot copy or even access it outside of QV. The data should all be the same, but I cannot vouch for it. I will try to get some rights to access the database tomorrow . I think I will repost then. Thank you anyway for your help.

Re: Wrong format

Gysbert_Wassenaar — Mon, 04 Mar 2013 16:50:25 GMT

Change the alignment on the Presentation tab of the object properties. Or in the script use the text() function to load the field as text:

Load

text(MyField) as MyField

from ...somewhere...;