Formato Miles Qlikview

[#1]

Buenas tardes,

Soy nuevo en esto de Qlikview, y me estoy peleando con un cuadro de texto que tengo formulado con set analisis.

La expresión es la siguiente:

= num(sum({<COUNTRY = {'ESPAÑA'}>}[VOLUMEN TRANSACIONES]),' #.##0')

De ella obtenemos el número 12.345.211,42 pero yo realmente lo necesito en formato de miles es decir que sea 12.345,21.

No quiero modificar en el script la forma de representar mi número ya que depende para que necesito unos u otros. Por favor alguien podría decirme como agruparlo?

Good afternoon,

I'm new to this from Qlikview, and I'm struggling with a text box I've formulated with set analysis.

The expression is as follows:

= Num (sum ({<COUNTRY = {'SPAIN'}>} [VOLUME TRANSACTIONS]), '#. ## 0')

From it we get the number 12.345.211,42 but I really need it in thousands format that is to say 12.345,21.

I do not want to modify in the script how to represent my number since it depends so that I need one or the other. Could someone please tell me how to group it?

[sunny_talwar]

Try this

=Num(Sum({<COUNTRY = {'SPAIN'}>} [VOLUME TRANSACTIONS]), '#.##0,00', ',', '.')

[#3]

Sorry,

It doesn't working, this formule give-me de whole number with 2 decimals.

I add some more information, maybe today de transactions volume is 12.345.211,42 and I need only thousands 12.345,21.

And tomorrow could 644.392,21 and I need 644,39

I use "," as decimal separator and "." thousands separetor.

Could you help me?

Thank you very much Sunny!

[sunny_talwar]

It should work the way you described.... I tried this

Here the decimal separator is comma (,) and thousand separator is full stop (.). Not sure why it doesn't work for you.

[CarlosAMonroy]

Hola Daniel,

Porque no divides la formula entre mil, y usas el formato numerico que tienes??

Espero te sirva.

Carlos M

[#6]

Buenos días Carlos,

= num(sum({<COUNTRY = {'ESPAÑA'}>}[VOLUMEN TRANSACIONES]),'#.##0', ',', '.') = 6.446.117

Lo había probado, pero cuando divido entre 1000 la anterior fórmula me transforma el formato de número y queda así: 6446,117 me quita el punto de los miles y pone 3 décimales y yo necesito estrictamente: 6.446,11

¿Sabrías como debo hacer?

[sunny_talwar]

May be this?

=Num(Sum({<COUNTRY = {'SPAIN'}>} [VOLUME TRANSACTIONS])/1000, '#.##0,00', ',', '.')

[#8]

Very close Sunny!

Now, I have 6.446 but I need to add 2 decimals (6.466,11). COuld your help me?

Thanks you for your effort!

[sunny_talwar · Accepted solution]

Did you add the two decimal in your format?

=Num(Sum({<COUNTRY = {'SPAIN'}>} [VOLUME TRANSACTIONS])/1000, '#.##0,00', ',', '.')

[CarlosAMonroy]

‌= num(sum({<COUNTRY = {'ESPAÑA'}>}[VOLUMEN TRANSACIONES])/1000,'#.##0,00', ',', '.')