Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Partner
Partner

Formatting a Dimension for Money

I have a dimension field that I'm formatting for money as follows:

=Money([Amount]/1000000)

So that's turning $10,333,333 into $10.33, but I need to see three decimal places to the right to show $10.333.  How do I do that?

1 Solution

Accepted Solutions
Luminary
Luminary

Re: Formatting a Dimension for Money

Hi,

There are two ways to change money format.

 

1.Change [MoneyFormat] in data load editor.  This affect all money format.

WS0046.png

 

 

 

2.Change dimention to follows.This will only affect this dimension.

    =money([Amount]/1000000,'$#,##0.000;-$#,##0.000')

View solution in original post

1 Reply
Luminary
Luminary

Re: Formatting a Dimension for Money

Hi,

There are two ways to change money format.

 

1.Change [MoneyFormat] in data load editor.  This affect all money format.

WS0046.png

 

 

 

2.Change dimention to follows.This will only affect this dimension.

    =money([Amount]/1000000,'$#,##0.000;-$#,##0.000')

View solution in original post