Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Formato Miles Qlikview

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?

Tags (1)
1 Solution

Accepted Solutions

Re: Formato Miles Qlikview

Did you add the two decimal in your format?

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

Capture.PNG

10 Replies

Re: Formato Miles Qlikview

Try this

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

Not applicable

Re: Formato Miles Qlikview

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

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

Capture.PNG

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

CarlosAMonroy
Contributor III

Re: Formato Miles Qlikview

Hola Daniel,

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

Espero te sirva.

Carlos M

Not applicable

Re: Formato Miles Qlikview

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

May be this?

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

Not applicable

Re: Formato Miles Qlikview

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

Did you add the two decimal in your format?

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

Capture.PNG

CarlosAMonroy
Contributor III

Re: Formato Miles Qlikview

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

Community Browser