topic Re: Qilk-Sense-Chartjs Format Number in App Development

Qilk-Sense-Chartjs Format Number

Anonymous — Thu, 29 Sep 2016 19:27:58 GMT

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

Re: Qilk-Sense-Chartjs Format Number

Thu, 29 Sep 2016 20:23:14 GMT

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

Re: Qilk-Sense-Chartjs Format Number

Anonymous — Thu, 29 Sep 2016 20:37:22 GMT

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

Re: Qilk-Sense-Chartjs Format Number

shraddha_g — Fri, 30 Sep 2016 03:52:11 GMT

Try same number format in measure

for ex:

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

Re: Qilk-Sense-Chartjs Format Number

lakshmikandh — Fri, 30 Sep 2016 07:43:42 GMT

Hi,

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

Decimal Separator and Thousand Separator.

Hope this helps.

Thanks,

Lakshmikandh

Re: Qilk-Sense-Chartjs Format Number

antoniotiman — Fri, 30 Sep 2016 07:51:34 GMT

Hi Jonathan,

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

Regards

Re: Qilk-Sense-Chartjs Format Number

Anonymous — Fri, 30 Sep 2016 12:42:58 GMT

Thanks Lakshmikandh but my data editor already have that configuration

Re: Qilk-Sense-Chartjs Format Number

Anonymous — Fri, 30 Sep 2016 12:48:06 GMT

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

Re: Qilk-Sense-Chartjs Format Number

Anonymous — Fri, 30 Sep 2016 12:52:27 GMT

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

Re: Qilk-Sense-Chartjs Format Number

Anonymous — Fri, 30 Sep 2016 12:57:31 GMT

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

];

Re: Qilk-Sense-Chartjs Format Number

schivet — Wed, 31 May 2017 11:25:01 GMT

Hello Jonathan,

I think it will work if you delete your measure from your dimension and add it again

Regards

Stéphane

Re: Qilk-Sense-Chartjs Format Number

Anonymous — Wed, 31 May 2017 13:35:31 GMT

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