Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Partner
Partner

hi

Try using Num() Function to format your values

Hope this helps

Thanks

Anismohamed32
Partner
Partner

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
Partner
Partner

Hi

Set the format as a measure expression 

Thanks