Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

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
Highlighted
MVP
MVP

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

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.

Highlighted
Partner
Partner

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

hi

just used this set up and it seems to work

SET ThousandSep=' ';

and

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

Highlighted
Contributor

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

Thank you very very much, it works !

Highlighted
Contributor

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

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.