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?
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.
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).