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: 
mhmmd_srf
Creator II
Creator II

Sales in Text Box

Hi All,

I have a Text Box, containing sum(Sales) in expression.

Now I want to show this with comma in numbers. As there is no option for number. I am not able to select any property.

Please help.

Thanks,

Sarif

1 Solution

Accepted Solutions
sunny_talwar

Use Num() function

Num(Sum(Sales), '#,##0')

View solution in original post

3 Replies
sunny_talwar

Use Num() function

Num(Sum(Sales), '#,##0')

sravanthialuval
Creator
Creator

Hi,

You should specify number format in terms of  Expression like num(expression,'number format expression').

It will give you the number separated by comma's.

EX:

num(sum(Sales),'#,##0')

hector_munoz
Specialist
Specialist

Hi,

When you use Num() function, first parameter is the expression, second the mask, third the decimal separator and fourth the thousand separator.

Regards,

H