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

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

Words and an Expression

I have a text object in which I would like to display the following:

Total: ##,###

How would I format the expression. I tried ' Total ' & =sum(twnow+fbnow+innow) but received an error

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer
MVP
MVP

Try this: = 'Total ' & num(sum(twnow+fbnow+innow), '##,###')

- Marcus

View solution in original post

4 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Maybe: ='Total: ' & sum(twnow+fbnow+innow)

Saludos.

marcus_sommer
MVP
MVP

Try this: = 'Total ' & num(sum(twnow+fbnow+innow), '##,###')

- Marcus

evansabres
Specialist
Specialist
Author

Thank you

evansabres
Specialist
Specialist
Author

Thank you, this work perfectly