# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor III

## Number Format

Hi.

I have below expression that sits in a pivot table under dimensions.

Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Description EP]={'Winter'}>}[Binc Sale Sell Amt])), Division, Department).

This is returning the number format of 123456789.

I would like the above expresion to return 123 456 789.

How am I able to achieve that?

Labels (15)

• ### qliksenseexpert

1 Solution

Accepted Solutions
MVP

Hi

Try like below

=Num(Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Description EP]={'Winter'}>}[Binc Sale Sell Amt])), Division, Department), '# ##0','.', ' ')

Thanks & Regards,
Mayil Vahanan R
4 Replies
MVP

HI

Try like below

Num(Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Description EP]={'Winter'}>}[Binc Sale Sell Amt])), Division, Department),'# ###')

Thanks & Regards,
Mayil Vahanan R
Contributor III
Author

Hi

It's returning 1e+07 ###

MVP

Hi

Try like below

=Num(Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Description EP]={'Winter'}>}[Binc Sale Sell Amt])), Division, Department), '# ##0','.', ' ')

Thanks & Regards,
Mayil Vahanan R
Contributor III
Author

Hi

This is giving expected result, thanks.

Tags
Community Browser