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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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!