Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
noman212
Creator III
Creator III

Comma Separator in Expression

Hi Community,

I want to put comma seperator in a text object this expression returns values like 2500000000.

when i put ,'#,##0'

like

FirstSortedValue(AGGR(if(ModeType='A',Round(sum({$<statuscode={'13'}>} Annual,'#,##0')),

But it returns null value.

Please Help.

Original Expression :

=FirstSortedValue(AGGR(if(ModeType='A',Round(sum({$<statuscode={'13'}>} Annual)),

if(ModeType='H',Round(sum({$<statuscode={'13'}>} Half)),

if(ModeType='Q',Round(sum({$<statuscode={'13'}>} Quar)),

Round(sum({$<statuscode={'13'}>} Monthly))))),Clientname),

-AGGR(if(ModeType='A',Round(sum({$<statuscode={'13'}>} Annual)),

if(ModeType='H',Round(sum({$<statuscode={'13'}>} Half)),

if(ModeType='Q',Round(sum({$<statuscode={'13'}>} Quar)),

Round(sum({$<statuscode={'13'}>} Monthly)))))+rank(Clientname,Clientname)/10,Clientname),2)  & CHR(10) &

Regards

Noman khan

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

Try

=num(FirstSortedValue(AGGR(if(ModeType='A',Round(sum({$<statuscode={'13'}>} Annual)),

if(ModeType='H',Round(sum({$<statuscode={'13'}>} Half)),

if(ModeType='Q',Round(sum({$<statuscode={'13'}>} Quar)),

Round(sum({$<statuscode={'13'}>} Monthly))))),Clientname),

-AGGR(if(ModeType='A',Round(sum({$<statuscode={'13'}>} Annual)),

if(ModeType='H',Round(sum({$<statuscode={'13'}>} Half)),

if(ModeType='Q',Round(sum({$<statuscode={'13'}>} Quar)),

Round(sum({$<statuscode={'13'}>} Monthly)))))+rank(Clientname,Clientname)/10,Clientname),2)  & CHR(10) &,'#,##0')

View solution in original post

3 Replies
maxgro
MVP
MVP

maybe I don't understand but if you only want to format the expression expr

num(expr, 'format')

in your case num(expr, '#,##0')

swuehl
MVP
MVP

You can only use the format code in formatting (or interpretation) functions, like num(), not in aggregation functions like Firstsortedvalue().Embed your aggregation in a num() function. You may also need to specify your delimiters in the num() function, depending on your default settings.

sasiparupudi1
Master III
Master III

Try

=num(FirstSortedValue(AGGR(if(ModeType='A',Round(sum({$<statuscode={'13'}>} Annual)),

if(ModeType='H',Round(sum({$<statuscode={'13'}>} Half)),

if(ModeType='Q',Round(sum({$<statuscode={'13'}>} Quar)),

Round(sum({$<statuscode={'13'}>} Monthly))))),Clientname),

-AGGR(if(ModeType='A',Round(sum({$<statuscode={'13'}>} Annual)),

if(ModeType='H',Round(sum({$<statuscode={'13'}>} Half)),

if(ModeType='Q',Round(sum({$<statuscode={'13'}>} Quar)),

Round(sum({$<statuscode={'13'}>} Monthly)))))+rank(Clientname,Clientname)/10,Clientname),2)  & CHR(10) &,'#,##0')