Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Field values changing upon 'send to excel'

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

NameInstitution Code
Joe0018
James0003
Jill0102

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

NameInstitution Code
Joe18
James3
Jill102

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

2 Replies
Highlighted
Specialist III
Specialist III

Re: Field values changing upon 'send to excel'

Hey Matt,

Maybe try to enforce the text format like the below:

Capture.PNG

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

Hope this helps.

Highlighted
Employee
Employee

Re: Field values changing upon 'send to excel'

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

Capturar.PNG