Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
everest226
Contributor III

extension expression need $ sign in front of value

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

 

 

Outcome 

 

$456

Tags (2)
1 Solution

Accepted Solutions
everest226
Contributor III

Re: extension expression need $ sign in front of value

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 

5 Replies
Partner
Partner

Re: extension expression need $ sign in front of value

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

Capture.PNG

Partner
Partner

Re: extension expression need $ sign in front of value

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

Re: extension expression need $ sign in front of value

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 

Partner
Partner

Re: extension expression need $ sign in front of value

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

Re: extension expression need $ sign in front of value

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