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
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
cmillerclaritas
Contributor II
Contributor II

Qlik Sense Desktop Money Formatting Question

All, I'm trying to format a master field as money and take into account the fact that the field could have positive and negative values. I've checked the documentation but can't find a specific example of this.

How do I combine formatting for positive and negative numbers in the same formatting function? Or is there a different way to go about this? Specific example would be appreciated - format a sum of revenue to look like this: $1,000,000 or $ -$1,000,000 in one formatting function statement.

Thanks,

Chris

1 Solution

Accepted Solutions
PabloTrevisan
Partner - Creator II
Partner - Creator II

Hi Chris, try this in the script:

Num(yorfield,'U$#.##0,00;-U$#.##0,00') as field

View solution in original post

2 Replies
PabloTrevisan
Partner - Creator II
Partner - Creator II

Hi Chris, try this in the script:

Num(yorfield,'U$#.##0,00;-U$#.##0,00') as field

cmillerclaritas
Contributor II
Contributor II
Author

Thanks Pablo, that did the trick!