Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
DWolsie
Contributor III
Contributor III

Remove decimals in KPI after adding text

Hello everyone,

I've been using a master-element in a KPI and it looks like this:

DWolsie_2-1729078173265.png

 

 

I now want to add a string of text to the end of it. By doing so, it seems to automatically add the decimals back:

DWolsie_1-1729078160447.png

 

 

The code looks like this right now:

DWolsie_0-1729078148528.png

 

Is there a way to code these out? Thanks in advance!

Labels (1)
1 Solution

Accepted Solutions
Camilla84
Partner - Contributor III
Partner - Contributor III

Hi, @DWolsie 

You can try:

Num([COSP Budget], '#,##0') & .... the rest of your set analysis. 

View solution in original post

2 Replies
Camilla84
Partner - Contributor III
Partner - Contributor III

Hi, @DWolsie 

You can try:

Num([COSP Budget], '#,##0') & .... the rest of your set analysis. 

DWolsie
Contributor III
Contributor III
Author

Thanks! I had to use '###0' instead but now it works!