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: 
evansabres
Specialist
Specialist

Format Expression

I have an expression that appears as:

= 'Quantity Available:    '     &   NUM(SUM(vTotalCapacity)-(NUM(SUM(num_seats),'#,###.')))

vTotalCapacity = 71950

I want my expected output to be formatted as ##,###, however I cannot get the expression to have that output, the result is formatted as #####, with no separator as I am attempting to do.

Have I structured this equation incorrectly?

1 Solution

Accepted Solutions
sunny_talwar

Try this

= 'Quantity Available:    '     &   Num((Sum(vTotalCapacity) - Sum(num_seats)), '#,###.')

View solution in original post

1 Reply
sunny_talwar

Try this

= 'Quantity Available:    '     &   Num((Sum(vTotalCapacity) - Sum(num_seats)), '#,###.')