How to attach a dynamic money value (Currency) to a amount measure

[cshendokar]

Hi,

In the view we have a separate dimension called ‘doc_currency’ with multiple currencies such as USD, EUR, HKD, SEK etc. these currencies are filtered by the country. Each country has the Gross Amount field, in the result we would like show the Gross amount like 103.05 USD, 105.43 SEK and so on.

As we have Country as a filter, how to use doc_currency dynamically in LookML to display the amount with currency based on country  ?

Regards,

Chandra

[mpazbernal95-16]

I believe that on this case they are two options:

• Use logical operators on liquid for the HTML parameter.
• Use the case parameter to concatenate both values based on the city you select.

To make it dynamic, you can maybe use parameters to select a currency or based if the value is in query.