Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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