I would like to have my QV doc available in different languages. The choice of the manguage would be available in a multibox (up to now, there is no problem).
But I don't want to duplicate every sheet, so I want to use variables in my different pages for text, and then these variables would take the value corresponding to the chosen language.
For example, I would have a variable "DataSelection", and it would take the value "Sélection de données" in French or "Selection Of Data" (not very good but it is just to distinguish it from the variable name) in English.
So I created a table on excel with:
Gestionnaire de bâtiment
My question is:
How do I do to load it in order then that as soon as I choose French, every variable in column 1 take the value on column 2 (value1)?
You should load it in to a table with the field Language, Variable and Value, so that by a language selection you only have the values for that language available. This should be possible to accomplish with the tranformation features like Transpose in the table load wizard.
In the application you can then pick the string with a set expressions like
I agree, for maintenance you should keep your original structure. This is also what I meant by transforming the data during load by using the QlikView tranformation features. Sorry for mixing things up, you should use the Cross Table feature to twist the sheet data. Find principle steps below, and sample files.