topic Re: Formato Miles Qlikview in QlikView

Formato Miles Qlikview

Mon, 13 Mar 2017 19:10:04 GMT

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?

Re: Formato Miles Qlikview

sunny_talwar — Mon, 13 Mar 2017 19:13:37 GMT

Try this

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

Re: Formato Miles Qlikview

Mon, 13 Mar 2017 19:21:44 GMT

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!

Re: Formato Miles Qlikview

sunny_talwar — Mon, 13 Mar 2017 19:24:09 GMT

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.

Re: Formato Miles Qlikview

CarlosAMonroy — Mon, 13 Mar 2017 20:30:10 GMT

Hola Daniel,

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

Espero te sirva.

Carlos M

Re: Formato Miles Qlikview

Tue, 14 Mar 2017 08:16:35 GMT

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?

Re: Formato Miles Qlikview

sunny_talwar — Tue, 14 Mar 2017 09:23:19 GMT

May be this?

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

Re: Formato Miles Qlikview

Tue, 14 Mar 2017 10:38:24 GMT

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!

Re: Formato Miles Qlikview

sunny_talwar — Tue, 14 Mar 2017 10:42:27 GMT

Did you add the two decimal in your format?

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

Re: Formato Miles Qlikview

CarlosAMonroy — Tue, 14 Mar 2017 11:03:51 GMT

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

Re: Formato Miles Qlikview

Tue, 14 Mar 2017 11:04:49 GMT

Damn! It's true!!!!

Thanks I close this conversation!

I'm very gratefull for your help