Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
mgarcmun
Contributor II
Contributor II

Custom Number Format in Qlik Sense Chart

Hi Everyone!

I've one doubt about how to personalize the following data in a line chart:

     Month          v.MyValue

     201801        1.020.000

     201701           873.850

I've customized the format number with K or M and 2 decimals with the next Expression :

IF(FABS($(v.MyValue)) > 1000000,num($(v.MyValue)/1000000, '#.##0,00M', ',', '.'),if(FABS($(v.MyValue)) > 1000, num($(v.MyValue)/1000,  '#.##0,00K', ',', '.'), num($(v.MyValue), '#.##0,00', ',', '.')))";

     Month          v.MyValue

     201801        1,02 M

     201701           873,85 K

I think that is correct but in a chart doesn't work as I would like:

Untitled.png

Has someone else other idea to do the custom format number with the high value on the top of the chart?

Thank you very much.

Teresa.

[ES] En Qlik Sense, cuando creo una medida en elementos maestros, le añado en dicha expresión un formato numérico específico (2 decimales y dependiendo del valor millones M o miles K). Si la utilizo en una gráfica, la gráfica no dibuja bien los valores debido quizás a la multiplicación que utilizo en dicha expresión, no obstante, me gustaría que se mostrara con ese formato pero que los millones aparezcan por encima de los miles (como es lógico).

Por cierto, he intentado poniendo la medida con formato automático, y sí que aparece con los M o K a diferencia de que pone los decimales que le da la gana, y necesitaría por favor el formato con dos decimales.

Si alguien conoce alguna forma alternativa de realizarlo, por favor conteste a mi pregunta.

Muchas Gracias!

Teresa.

1 Solution

Accepted Solutions
Zhandos_Shotan
Partner - Creator II
Partner - Creator II

Hi!

It seems like it will work automaticly by QlikSense.

Since April2018 release you can use custom NumericalAbbreviation to define k, M, G...


Set NumericalAbbreviation='3:t;6:M;9:B;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:µ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

Reference:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/NumberInterpretationVar...

View solution in original post

3 Replies
Zhandos_Shotan
Partner - Creator II
Partner - Creator II

Hi!

It seems like it will work automaticly by QlikSense.

Since April2018 release you can use custom NumericalAbbreviation to define k, M, G...


Set NumericalAbbreviation='3:t;6:M;9:B;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:µ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

Reference:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/NumberInterpretationVar...

MK9885
Master II
Master II

did you try

IF(FABS($(v.MyValue)) > 1000000,num($(v.MyValue)/1000000,'#,##0.00 M'),if(FABS($(v.MyValue)) > 1000, num($(v.MyValue)/1000, '#,##0.00 K'), num($(v.MyValue),'#,##0.00')))";

mgarcmun
Contributor II
Contributor II
Author

It works fine!

Thank you so much!