Creating a Multi-Language Qlik Cloud App

[Polrb7]

Hi everyone,

I was recently asked to add a multi-language feature to a Qlik Cloud app, and I’d like to share how I accomplished it:

Step 1: Create a Translation Excel File

First, I created an Excel file to manage all the words that appear in the app and their translations for the desired languages. In my case, I included English (EN) and Spanish (ES).

The Excel file contains the following columns:

• Translation ID: A unique identifier created by concatenating various IDs. For example:

  • Id_0: Uses D for Dimensions, M for Metrics, and L for Labels.

  • Additional IDs: Custom names for clarity.

• Table_Dimension: An informational column indicating the table where the field originates.

• Language Columns: Each column represents a language, containing the text to display in the app for that language.

• Load Flag: A final column to mark whether a row should be loaded into the app.
  
  

---

Step 2: Add the Script

Next, I added the following script to the app:

---

Step 3: Create Variables

I created two variables to manage language selection:

1. vG.Value.Language: Stores the default language (e.g., EN).

2. vG.Value.Multi.Language: Retrieves the corresponding translation based on the selected language:

   Only({<[Translation ID]={$1}>} $(vG.Value.Language))

---

Step 4: Add a Language Selector

Using the Variable Input chart from the Qlik Dashboard Bundle, I added a drop-down menu to let users select the language.

---

Step 5: Apply Translations

Finally, I applied the translations to texts and tables across the app. To quickly test this feature:

1. Add the drop-down menu and a text box to an empty sheet.

2. In the text box, use a measure with the following expression:

   $(vG.Value.Multi.Language('D.Year'))

   • $(vG.Value.Multi.Language) is the variable for fetching translations.

   • 'D.Year' is the Translation ID from the Excel file.
     
     

     

---

I hope this guide is helpful!

Best regards,
Pol Romeu