Qlik Community

Qlik Sense App Development

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

sebbertoletto
New Contributor

[QlikSense] Num function doesn't work

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.


Qlik Num Function.jpg

Have u any idea ?

Thanks,

Sébastien B

2 Replies
neha_shirsath
Valued Contributor

Re: [QlikSense] Num function doesn't work

Hi,

Use This below expression.

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

or

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


Regards,

Neha

rnt
Valued Contributor

Re: [QlikSense] Num function doesn't work

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:

  • Change the ThousandSep setting in the load script

or

  • 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.