Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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