Displaying number separators as it is in Regional Settings

[#1]

Hello,

We are distributing a QlikView document using QlikView Publisher. Some customers has [.] as decimal separator, some has [,] .Everybody needs to analyze QV document in his own format.

Document is loaded and saved with [,] as decimal separator.

Is it possible to achieve?

Thanks, Ramunas

[#2]

Hi,

just an idea to solve this using a button and change the format.

Good luck!

Rainer

[#3]

And here the application, I hope.

[#4]

But now ...

[justinasp]

Labas, Ramunas,

the only solution that gets into my mind is to use InputBox and macro (something like this):

Sub ChangeSeparators()
Set varA=ActiveDocument.Variables("DecimalSep")
Set varB=ActiveDocument.Variables("DecSymbol")
 valB=varB.GetContent.String
 varA.SetContent valB,true
End sub

Good luck,

Justinas

[#6]

Hi,

use an inline table:

Format:
LOAD * INLINE [
Format, Country
" '#,##0.00', '.',','", Eng
" '#.##0,00', ',','.'", Ger
];

an expression like this: Num(Sum(Amount), $(=Only(Format)))

and a button to choose the language as example.

Good luck!

Rainer