How to manage multilanguage data in Qlikview

Wed, 23 Jul 2014 15:27:31 GMT

Hi all,

I have a parameter table, in which the translation is stored per Country and per language

as following, categorized by param_type. The param_code is used for the mapping to extract the param_text . Note that there are not always translation (text) in all languages, if no text/translation is found, we show the code instead

param_type	param_country	param_langue	param_code	param_text
param_group	USA	EN	chd01	Demonstration
param_group	USA	FR	chd01	Démonstration
param_group	FRA	FR	chd01	démo FR
param_group	FRA	FR	chd01	démo FR
param_group	USA	FR	cheveryone	Région Everyone
param_group	FRA	EN	cheveryone	Region Everyone
param_group	FRA	FR	chl01	Linéaire 01
param_group	USA	EN	chl01	Linear 1
param_group	USA	EN	chl99	Key-Account
param_group	FRA	FR	chl99	k-accounts
param_system	USA	EN	sys1	System 1
param_system	USA	FR	sys1	Système 1
param_system	FRA	FR	sys1	Système 1
param_system	USA	EN	sys2	System 2
param_system	FRA	FR	sysw	Système 2

Data is store as following, we need to display on the interface (as dimension of a pivot table) the text/description corresponding to the codes: values in column "group_code" can be found within param_type = 'param_group' according to the Country (available in data rows and the application's language (do not available during scriptting, but via a variable vDataLanguage)

id	country	group_code	system_code	price
1	USA	chl01	sys1	100
2	FRA	chd01	sys2	200
3	USA	chl99	sys1	500

I need to achieve the following

If vDataLanguage = FR
ID	Country	Group	System	Price
1	USA	(chl01)	Système 1	100	(chl01 has no translation in USA / FR so we show the code)
2	FRA	démo FR	Système 2	200
3	USA	(chl99)	Système 1	500	(chl01 has no translation in USA / FR so we show the code)

If vDataLanguage = EN
ID	Country	Group	System	Price
1	USA	Linear 1	System 1	100
2	FRA	démo FR	(sys2)	200	(sys2 has no translation in FRA / FR so we show the code)
3	USA	Key-Account	System 1	500

I had followed a solution, which is add 2 additional columns per param_type ( for example group_text_EN, group_text_FR, etc...)into the Data table during load, using ApplyMap. Then once in the interface, I set up the expression inteads of a fixed field (If vDataLanguage = 'EN', group_text_EN, group_text_FR). The problem is, when a user select a value, in Active Selection box, we see both fields appeared (group_text_EN = 'value', group_text_FR='...'). Even worse because in reality I have 3 languages.

Any proposal to improve or do this differently ?

Thanks a lot

topic How to manage multilanguage data in Qlikview in QlikView

How to manage multilanguage data in Qlikview