Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
benazirkhan
Creator II
Creator II

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

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

1 Solution

Accepted Solutions
md_qlikview
Creator II
Creator II

Hi,

Try using text function for brand id.

View solution in original post

2 Replies
md_qlikview
Creator II
Creator II

Hi,

Try using text function for brand id.

View solution in original post

benazirkhan
Creator II
Creator II
Author

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