Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, Qlikers!
I have values in my project that eventually comes into different format from database. I can't use same format pattern for all of them because that problem. I have an example below:
DB How I need to format
31294345 = 31.294
44100.7 = 44.100
43250.7 = 43.250
1328 = 1.328
12.9 = 12.9
Does anyone have faced something like that?
Tks,
Hi,
maybe try this on the script:
Num(FIELD, '#,##0', '.' , ',' ) as FIELD
Or this:
Num(FIELD, '#.##0', ',' , '.' ) as FIELD