Hello @BogdanT18,
As long as you export numeric data from a Qlik Sense object, the decimal separator will be derived from MS Excel settings, and you don't have any control over it from Qlik. As a workaround, I'd like to share a method that involves exporting data as text using the Text() function in combination with Num() to format the numeric data. For instance:
Text(Num(Sum(<FIELD_NAME>), '#,##0.00'))
This approach allows users to preserve the dot symbol as a separator even if the user's Excel settings have a comma as the decimal separator. However, this solution might not be ideal for various reasons. In light of this, I'd like to suggest considering alternative tools, such as Qlik nPrinting, to achieve more granular control over the export process.
Qlik nPrinting offers enhanced capabilities for creating pixel-perfect reports, providing users with greater control over numbers/text formatting, including decimal separators. This tool can be integrated seamlessly with Qlik Sense on-prem to generate polished and customized reports tailored to your specific requirements.
Best,
ilya
