Skip to main content
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 
Search instead for 
Did you mean: 
gisellevaleta
Contributor III
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?

1 Solution

Accepted Solutions
MayilVahanan

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.

View solution in original post

4 Replies
MayilVahanan

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.
gisellevaleta
Contributor III
Contributor III
Author

Hi

It's returning 1e+07 ###

MayilVahanan

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.
gisellevaleta
Contributor III
Contributor III
Author

Hi

This is giving expected result, thanks.