Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Davidqing1985
Contributor
Contributor
‎2024-01-18 01:44 AM

Send to Excel. Export Null value, showing empty in .xls file, but showing '-' in .xlsx file

Send to Excel. Export Null value, showing empty in .xls file, but showing '-' in .xlsxfile, it is number column, I want it showed empty, so only export to.xls file?

Could you resolve this problem or how to set configuration?

Labels (1)
Labels
332 Views
0 Likes
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2024-01-18 04:13 AM

@Davidqing1985 It will be nice to have one macro to change that with in xls file.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
303 Views
0 Likes