Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marieclaire
Creator
Creator

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

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 :

text box thousands.png

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,

4 Replies
swuehl
MVP
MVP

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
Partner - Master III
Partner - Master III

hi

just used this set up and it seems to work

SET ThousandSep=' ';

and

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

marieclaire
Creator
Creator
Author

Thank you very very much, it works !

marieclaire
Creator
Creator
Author

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.