topic Re: [QlikSense] Num function doesn't work in App Development

[QlikSense] Num function doesn't work

sbertoletto — Tue, 24 Mar 2015 10:22:56 GMT

Hello,

i had an error in QlikSense when i want to format expression. Here is my expression :

=num(sum(Total_unemployment),'# ##0')

It's working with Qlikview but there is an issue with QlikSense.

Have u any idea ?

Thanks,

Sébastien B

neha_shirsath — Wed, 25 Mar 2015 06:10:08 GMT

Hi,

Use This below expression.

num(sum(Total_unemployment),'#,##0')

num(sum(Total_unemployment),'###0')

Regards,

Neha

Ralf-Narfeldt — Wed, 25 Mar 2015 07:01:08 GMT

Which settings do you have for thousand separator in the data load script? It should be a space for this to work:

SET ThousandSep=' ';

I guess you have another setting.

There are two alternatives:

Override it in your expression when you use NUM():
num(sum(Total_unemployment),'# ##0', ',' ,' ')
The 3rd parameter is decimal separator,( I set it to a comma), and the 4th parameter is the thousand separator which I set to a space.