Qlik Community

Ask a Question

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

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

View solution in original post

gisellevaleta
Contributor III
Contributor III
Author

Hi

This is giving expected result, thanks.