topic Re: Trying to export to excel - is there a way to force format the export? in QlikView

Trying to export to excel - is there a way to force format the export?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Whenever I export my table, all the brand IDs that go like 001,011,035 etc. are getting formatted to drop the leading zeroes. For any other column, this would be acceptable, but for Brand ID - the user doesn't want the leading zeroes to get formatted as 1,11,35 etc.

How can I force the export to not format it?

Regards,

Benazir

Re: Trying to export to excel - is there a way to force format the export?

md_qlikview — Sat, 14 Jul 2018 09:55:45 GMT

Hi,

Try using text function for brand id.

Re: Trying to export to excel - is there a way to force format the export?

Anonymous — Sat, 14 Jul 2018 11:53:27 GMT

Thank you Milind. It worked! Is there another way at table level or document level properties to work with the formats? This "text" function method will have to be used at a granular elvel.. a global setting may be a better option..

Regards,