Window Title with different languages

[thanhphongle]

Hello Community,

I created a Database (see attached) in which I translated all words in 4 different languages. What I want to do is, to set a fix language by clicking one time on a value in a listbox which stays constantly even if I press the clear button after clicking in other listboxes. What I exactly mean is if I choose English, it should stay active the time. If I switch the language to german it should leave english and set german active.  Even if If I press on the clear button, one certain language should stay active at least.

Another point is, that I want add an Expression at all titles. For example the Window Title.

When I click on a certain language, it should translate it to the chosen language. I used this expression, but I dont know if this one is correct.

=sum(total{<Code={W10001}>} Word)

somehow it shows me 0 as title.

if I use the if expression like  =if(Code='W10001', Word)   it is only working if i chose the code and the language in a listbox before.

Is there any possibility if I just click on a language so that the title just return the word to the referring language?

I attached my QV file. Hope someone can help me out here.

[sunny_talwar]

Make the list box for language have only one selected value. Check the attached?

[jagan · Accepted solution]

Hi,

Make the language field selection mandatory by using Always One Selected value in Listbox properties and use below expression.

=Only({<Code={W10001}>} Word)

Regards,

Jagan.

[satishkurra]

You can also refer the qvw file Movies Data Base.qvw which Qlik provides on installation. You can see the complete dashboard is multi language implemented...

[thanhphongle]

Thank you, this is working. I thought it should be the sum expression.