Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Boberts227
Contributor II
Contributor II

Money Expression Formatting Issues

In my Qlik Sense pivot table, I have multiple data format types per measure row. For example, I have values that should appear as currency ($#.##) and others that should appear as percentages (#.##%). I am having difficulty formatting each of these values using the built-in Auto and Number formats under the measure attributes. 

Can someone provide context on the expression I could use on the following to make it display as currency? 

 

(SUM({$<Scenario_NORMALIZED={'Total Actual'},"Year"={'$(Current_Year)'},View_NORMALIZED={'MTD'},Period={'$(Current_Month)'},"Index"={'PR9'},"Finance Geography_NORMALIZED"={'$(VZ_Area)'}>}Value)/2),

5 Replies
Kashyap_R
Partner - Specialist
Partner - Specialist

hi

Try using Num() Function to format your values

Hope this helps

Thanks

Thanks and Regards
Kashyap.R
Anismohamed32
Partner - Contributor III
Partner - Contributor III

Hi,

Do you want to change the formats of the values of a single column or for different columns.

 

For Currency kind of measure, if you need a standard currency sign and format to overall application, make the Data type of the measure as Money and set the exact format needed in the set function on the main section of the load editor.

Set MoneyFormat={'$#,##.#0','-$#,##.#0'};

By Qlik_KiD

 

 

qlikerB96
Contributor III
Contributor III

Hi,

The easiest way is to use the Num() function.

Num(SUM({$<Scenario_NORMALIZED={'Total Actual'},"Year"={'$(Current_Year)'},View_NORMALIZED={'MTD'},Period={'$(Current_Month)'},"Index"={'PR9'},"Finance Geography_NORMALIZED"={'$(VZ_Area)'}>}Value)/2, '$#.##')

Good luck,

B.

Boberts227
Contributor II
Contributor II
Author

I've tried wrapping my expression in the MONEY and NUM syntax, with '$#,##0.00;-$#,##0.00', but am not yielding the desired results. 

What does the Measure Number Formatting need to be selected as? When I use Measure Expression, my value displays as NaN. I can adjust the Number Formatting to Money, but then I lose my percent formats (see attached).

Thanks.

Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

Set the format as a measure expression 

Thanks

Thanks and Regards
Kashyap.R