Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
mhmmd_srf
Contributor 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

Re: Sales in Text Box

Use Num() function

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

View solution in original post

3 Replies

Re: Sales in Text Box

Use Num() function

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

View solution in original post

sravanthialuval
Contributor

Re: Sales in Text Box

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
Valued Contributor

Re: Sales in Text Box

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