KPI in textbox : How to obtain this value format '# ###' ?

[marieclaire]

Hi everbody,

Although i read a lot of threads about KPI in text box, I don't manage to get a separator ' ' for the thousands :

with the expression :

=Num#(Sum([Visites]),'# ###') & chr(10) & 'Visites '

The configuration of the thousands in the "main" tab is :

SET ThousandSep=' ';

Any idea ?

Thank you for your help,

[swuehl]

Num#() function is for interpreting values as numbers, not for formatting. If you want to format values, you need to use Num() [without the hash '#'].

Try

=Num( Sum([Visites]), '# ###.','.',' ') & Chr(10) & 'Visites '

Depending on your default separators, you don't need to specify the separators within the num() function, maybe not even the format code, but I would start from defining the format as detailed as possible.

[lironbaram]

hi

just used this set up and it seems to work

SET ThousandSep=' ';

and

=num(Count(Rule),'# ##0')

[marieclaire]

Thank you very very much, it works !

[marieclaire]

Hi Leron,

It doesn't work if i only use '# ##0'.

I don't know why, but it works with this format '# ###.','.',' '  on my qlikview release.

Thank you for your help.