Convert number into thousands in qliksense

[BI_Rockstar_265]

Hi,I want to convert Number into Number with separated by comma in KPI(Qliksense).

I have tried multiple ways but nothing is worked as of now.

What is the default way for any number format in qliksense

[Dalton_Ruer]

1. Simply set the Number format in the properties for the KPI per this example image. 

2. The "defaults" regarding formats are established in the Load Script for each application and can be changed to handle European version of numbers and dates etc. 

[BI_Rockstar_265]

Hi,

Its not working  as you mentioned in above 2 ways.

[Dalton_Ruer · Accepted solution]

Can you share a screen shot of what you see in the properties for your KPI like I shared above? 

[JordyWegman]

Hi,

@Dalton_Ruer had a good way, but check out the Num() function! 

With this function you need to use the 2nd and 3rd operator to overrule the normal separator and thousand separator.

Jordy 
Climber 

[BI_Rockstar_265]

I got the output with other expression in backend script(removing $ symbol).

Thanks

[JordyWegman · Accepted solution]

That's also cool. Please mark the post as solved!

Jordy

Climber