Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
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')))";

Highlighted
Contributor II
Contributor II

It works fine!

Thank you so much!