Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
nikolaus
Contributor
Contributor

Format numbers and money with leading +

Hello,

after the update to August 2023 Patch 2 - 14.139.6 I have noticed following difference: With older versions I could use the number format +0,00%;-0,00%; in a straight table. After the update the format still works but the data could not be exported with keeping the format.

Every Excel Export has the size of 9KB and could not be opened "corrupt fileformat"

When I change the format to Auto and change the expression like below, the export works again:

=num( ([Monatsumsatz]-[Monatsumsatz Vorjahr]), '+ #.##0,00 €; - #.##0,00 €; ')

It seems that the problem is related to the € sign.

1. Has anybody else noticed this behavoir?

2. What is the best way to get a leading + for numbers, money?

Thanks

Niko

 

Labels (1)
0 Replies