Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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
Please close the thread by marking correct answer & give likes if you like the post.
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
Please close the thread by marking correct answer & give likes if you like the post.
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
Please close the thread by marking correct answer & give likes if you like the post.
Contributor III
Author

Hi

This is giving expected result, thanks.