Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

extension expression need $ sign in front of value

Sum({< Isno={'N'}, [ Name] = {'USA'}  >} [ Cost] )

 

 

Outcome 

 

$456

1 Solution

Accepted Solutions
everest226
Creator III
Creator III
Author

here what i did 

Sum({< Isno={'N'}, [ Name] = {'USA'}  >} [ Cost] ) /1000000

and Number formatting  to Money

and Format pattern to  $#,##0 M;-$#,##0 M

 

works perfectly 

View solution in original post

5 Replies
dplr-rn
Partner - Master III
Partner - Master III

you give that in the number format rather than on the expression.
give number formatting as Money in qlik sense

Capture.PNG

dplr-rn
Partner - Master III
Partner - Master III

alternatively add this to your expression start
'$'&
everest226
Creator III
Creator III
Author

Thanks for reply  i have use auto format because i want outcome as    $61.81M.

if i use money it will be $613654654 something for example , just want to be  above format 

dplr-rn
Partner - Master III
Partner - Master III

you can still format that again
divide your expression by a million and change the format to $#,##0.00 M
everest226
Creator III
Creator III
Author

here what i did 

Sum({< Isno={'N'}, [ Name] = {'USA'}  >} [ Cost] ) /1000000

and Number formatting  to Money

and Format pattern to  $#,##0 M;-$#,##0 M

 

works perfectly