Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String + a number (Expression syntax problem)

Hi guys,

I'm trying to write something like this...
Total sales: num(sum( {$<Region= {'Tristate'} >} [Sales] ),'##,###.##')

Where total sales: is a string. How do I form them together? I would like to display it in a textbox!


Thanks for anyone who can help!

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

= 'Total sales: ' & num(sum( {$<Region= {'Tristate'} >} [Sales] ),'##,###.##')


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

= 'Total sales: ' & num(sum( {$<Region= {'Tristate'} >} [Sales] ),'##,###.##')


talk is cheap, supply exceeds demand