Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
hi
just used this set up and it seems to work
SET ThousandSep=' ';
and
=num(Count(Rule),'# ##0')
Thank you very very much, it works !
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.