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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

1 Solution

Accepted Solutions
marcus_sommer

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

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

- Marcus

evansabres
Specialist
Specialist
Author

Thank you

evansabres
Specialist
Specialist
Author

Thank you, this work perfectly