Qlik Community

Qlik Sense App Development

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

jonathanruiz
New Contributor III

Qilk-Sense-Chartjs Format Number

Hello, I have a problem by placing a number format to a measure in the extension Qilk-Sense-Chartjs, my original number is 200000, I would like to see 200.000,00 but when I put the format #.##0.00 is seen as 200,000.000,00, do you know someone that format should I use? Thanks



Imagen.png

1 Solution

Accepted Solutions
jonathanruiz
New Contributor III

Re: Qilk-Sense-Chartjs Format Number

thanks for your answer Stéphane, The author of the extension modified it and now it works correctly, thanks to all

11 Replies
Not applicable

Re: Qilk-Sense-Chartjs Format Number

use this Format  #.000,00 this can help You

jonathanruiz
New Contributor III

Re: Qilk-Sense-Chartjs Format Number

I do, but it does not work, Must be seen 134.777,00Imagen.png

Partner
Partner

Re: Qilk-Sense-Chartjs Format Number

Try same number format in measure

for ex:

num(expr,'#.000,00')

lakshmikandh
Valued Contributor II

Re: Qilk-Sense-Chartjs Format Number

Hi,

Please check your data load editor and try editing this place,

Decimal Separator and Thousand Separator.

attach.png

Hope this helps.

Thanks,

Lakshmikandh

antoniotiman
Honored Contributor III

Re: Qilk-Sense-Chartjs Format Number

Hi Jonathan,

Num(Field,'#.##0,00')

Regards

Highlighted
jonathanruiz
New Contributor III

Re: Qilk-Sense-Chartjs Format Number

Thanks Lakshmikandh but my data editor already have that configurationImagen.png

jonathanruiz
New Contributor III

Re: Qilk-Sense-Chartjs Format Number

Thank Sharaddha but when I put the function in a measure do I get as indefinite response

imagen2.png

jonathanruiz
New Contributor III

Re: Qilk-Sense-Chartjs Format Number

Thank Antonio but when I put the function in a measure do I get as indefinite response, i am using this extension http://branch.qlik.com/#!/project/576bab2754cc348900aeb122

jonathanruiz
New Contributor III

Re: Qilk-Sense-Chartjs Format Number

I am using this extension, http://branch.qlik.com/#!/project/576bab2754cc348900aeb122 and my test aplication is very simple, only a inline table and a bar chart


Table:

Load * inline

[

Month,Cantidad

Ene,155000

Feb,20000

Marz,134777

Abril,123456

Mayo,200000

];