Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomasowich
Contributor II
Contributor II

Multicurrency with MoneyFormat

Hi,

is it possible to adapt the MoneyFormat in Qlik so that the currency symbol changes based on the selections? Or else, is it possible to use a variable when choosing a Format pattern for measures in the Money format?

Thanks!

Labels (1)
1 Reply
Or
MVP
MVP

MoneyFormat is a script variable, which means it can't be adjusted based on selections (or rather, it means changing it won't impact anything without a reload).

You can use front-end formatting functions, though, e.g.

Money(1,'$(vTest)')

Where vTest is, in my example, $#,##0