How to make the Slice change Language

[Jack_Bates]

In the annualloadbook app the Language Change is working great except in one of the Reference  View. The data comes from the table {Expenses}, Slice {Expense HQ} The column that it uses from the slice is the Expense Column.

In the view for expenses the expense names do change language when the app user changes it. But not the names in the chart for the expense names.

The app view doesn’t changeThe Ref viewThe ref viewExpenses SliceThe filter conditionExpenses category totals

[Trevwiller · Accepted solution]

You will need to make a nested switch statement in a virtual column that is used for the chart instead of expense. This will switch back and forth for your languages providing the correct label.

SWITCH(USERSETTINGS("language"),
"Spanish", SWITCH([expense], "tax", "impuesto", "lodge", "alojamiento", ""),
"Chinese", SWITCH([expense], "tax", "税收", "lodge", "住宿", ""),   ""  ),
"French", SWITCH([expense], "tax", "impôts", "lodge", "hébergement", ""),   ""  )

Hope this helps!