Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Breezy
Creator II
Creator II

Table + add $$$ ?

Hi,

How can I get my "Amount" column to appear as number units? I thought using the Money# would have helped. For context, after "Amount" is 'from'.

Amounts2pics.JPG

 

 

Labels (1)
  • Chart

1 Solution

Accepted Solutions
G3S
Creator
Creator

if adding as  a  measure you can select from the drop down for  number formatting. 

G3S_0-1660699814021.png

 

View solution in original post

7 Replies
G3S
Creator
Creator

if adding as  a  measure you can select from the drop down for  number formatting. 

G3S_0-1660699814021.png

 

sidhiq91
Specialist
Specialist

@Breezy  if you want to use Amount as a Dimension, then you need to format it as below.

Num(Amount,'#,###.00')

if you want to use it as a Measure. Please see the screen shot below:

sidhiq91_0-1660705771027.png

 

Breezy
Creator II
Creator II
Author

Thanks, 

I think I'm adding it as a measure..

1. I clicked "number formatting" and chose money. 

2. For the following, I'm not sure how to get rid of the decimals:

$#,##0.00;-$#,##0.00

Is this correct? I don't want it to limit how large the number can be. I only want the decimals gone. 

$#,##0.

 

 

Amount3.JPG

G3S
Creator
Creator

hi, 

yes that's correct. can remove the period. if you don't want that showing. 

Breezy
Creator II
Creator II
Author

What does this even mean? 

$#,##0.00;-$#,##0.00

I can't find an article online explaining it all. I'm worried I might delete part of that in another column I'm working with. 

G3S
Creator
Creator

see this article:
https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Introduction/conventions-....

 

$#,##0.00;-$#,##0.00 :

first section in green : your number is to be formatted with a $ sign before the numbers, and the thousand separator is the comma. the number of 0 after the decimal point show how many decimal point you want to display. the red section is the similar, but shows how you want to display any negative numbers (in this case, with a minus in front of the $ sign and the rest of what is mentioned for green)

Breezy
Creator II
Creator II
Author

Wow! You explained that really well. Thanks!