topic Window Title with different languages in QlikView

Window Title with different languages

thanhphongle — Thu, 14 Apr 2016 15:49:41 GMT

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.

Re: Window Title with different languages

sunny_talwar — Thu, 14 Apr 2016 15:52:25 GMT

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

Re: Window Title with different languages

jagan — Thu, 14 Apr 2016 16:15:07 GMT

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.

Re: Window Title with different languages

satishkurra — Thu, 14 Apr 2016 16:48:13 GMT

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...

Re: Window Title with different languages

thanhphongle — Fri, 15 Apr 2016 08:02:55 GMT

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