Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
kamielrajaram
Creator III
Creator III

Leading zeros

Good day,

I am having an issue when exporting to excel, where the leading zero's are being dropped. How would I be able to resolve this.

Thank you in advance.

Kamiel

14 Replies
kamielrajaram
Creator III
Creator III
Author

the only way the change this is when loading -- text(fieldname)

clisboa_noesis
Partner - Creator
Partner - Creator

So... if that works why not use it?

kamielrajaram
Creator III
Creator III
Author

Does not work either

clisboa_noesis
Partner - Creator
Partner - Creator

Could you post an example .qvw?

And in which version does this happen (both QV and Excel)?

Not applicable

Same for us - Text() doesn't work - we are using version 10.