How to translate data

[#1]

Hi

I'm trying to add the possibility to set language in my qvw file. The default language is english, both in my qvw file and in the database which I load the data from. I want to be able to select language, so everything that the user will see is in his/hers selected language. I have started by creating an excel file with a column 'English' and then I add columns for each language.

I use the following syntax to set the language in a text box, diagram etc:

=Only({<English={'Order Name'}>} [$(=vLanguage)])

This works fine in most cases, but when I want to translate data from my database is it not allways posible to use that syntax. I have tried to use it on the following expression without success:

=If(ProductName='','Scrap & Wastage',ProductName)

I have several products under 'ProductName', but for scrap and waste is the product name blank. So I use the expression above to present the data with a text, but I can't make it work with the syntax for translation.

How can I translate the data from ProductName?

Should I use a different translation method than I used so far?

[swuehl]

You might want to take a look e.g. at the "Finance Controlling" demo app on demo.qlik.com, where they have multilanguage support in an app.

You could use a numerical TextID per Text portion you want to translate instead of the strings and then just do

=fieldvalue($(vLanguage),2)

to retrieve the TextID = 2 in language set by vLanguage.

It probably doesn't solve your problem with missing field values, could you elaborate on this? I haven't fully got what the issue here is.

Hope this helps,

Stefan