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

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

marieclaire — Sat, 24 Oct 2015 11:21:43 GMT

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,

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

swuehl — Sat, 24 Oct 2015 12:41:17 GMT

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.

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

lironbaram — Sat, 24 Oct 2015 12:41:31 GMT

just used this set up and it seems to work

SET ThousandSep=' ';

and

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

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

marieclaire — Sat, 24 Oct 2015 13:07:43 GMT

Thank you very very much, it works !

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

marieclaire — Sat, 24 Oct 2015 13:10:10 GMT

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.