Qlik Performance: Container or Changing Expression

[Shako]

Hello Everyone,

I have a Dashboard where I need to show data in Two Currencies: USD, EUR

All Measures are pre calculated meaning I have [Amount USD] , [Amount EUR] and I dont multiply Default Amount by USD or EUR currencies. And I need to Display a lot of similar measures in a single Table.

Now I have Two Options how to show data. For both cases I use Variable (Button) to Switch from USD to EUR or vise versa. My question would be which approach is better in general and performance wise:

a) Having One Table and creation of Variable Measures (or Master Measure) which will include pick( match( and switch from USD to EUR and recalculate all measures

b) Having Two Tables and creation of Container which will Show/Hide Tables where Measures are displayed accordingly to Currency Variable

[marcus_sommer · Accepted solution]

In regard to the efforts and performance I would probably include the variable within the expression, like:

sum([Amount $(var)])