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

[Anonymous]

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

[md_qlikview · Accepted solution]

Hi,

Try using text function for brand id.

[Anonymous]

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,

B