Field values changing upon 'send to excel'

mattphillip — Tue, 01 Sep 2015 15:21:13 GMT

I'm hoping someone can help. I have a table loaded into QV11 with the following values:

Name	Institution Code
Joe	0018
James	0003
Jill	0102

The institution code field values pull correspond to the full institution name. However, when I send the table to excel, I get the following:

Name	Institution Code
Joe	18
James	3
Jill	102

Does anyone have any idea on how to retain the zeros?

I had previously attempted to map the corresponding value within QV but as some of the values for different fields are the same (for example N/A, 1, A1), the mapping was incorrectly adding values from the wrong fields. Hence, the export and lookups (unless someone knows how I could get the mapping to work? Please note that the actual data has 12.5 million row and approx 30 columns).

Any help would be greatly appreciated.

Matt

Re: Field values changing upon 'send to excel'

sinanozdemir — Tue, 01 Sep 2015 15:37:03 GMT

Hey Matt,

Maybe try to enforce the text format like the below:

You can also use Text() in the front end as well.

Hope this helps.

Re: Field values changing upon 'send to excel'

Clever_Anjos — Tue, 01 Sep 2015 16:27:13 GMT

Not sure about what´s happening there. Here is ok, please find attached my sample

topic Re: Field values changing upon 'send to excel' in QlikView

Field values changing upon 'send to excel'

Re: Field values changing upon 'send to excel'

Re: Field values changing upon 'send to excel'