Translation with FieldValue, FieldIndex fails for duplicate strings

Wed, 23 Jul 2014 17:04:09 GMT

Hi folks,

I'm doing a translation using the technique applied in the infamous "Financial Controlling" demo application. This is also described here: http://www.citagus.com/citagus/blog/language-translator-multi-linugal-in-qlikview/

However, this technique fails as soon as there is a duplicate entry for any of the translations, as in my example app:

Translation2:

LOAD * INLINE [

Key, DE, EN

Hallo, Hallo, Hello

World, Welt, World

Quick, Schnell, Quick

Fast, Schnell, Fast

Foo, Bar, Baz

];

The words fast an quick are the same in German language (yes, you could argue that I should use synonyms, there are some, but thats not the point).

This leads to Qlikview storing "Schnell" only once and hence the FieldValue('DE', 3) evaluates to "Schnell" (correct), and FieldValue('DE', 4) to "Bar" (technically correct) while FieldValue('EN',4) evaluates to "Fast".

Is there anything I can do about? Except for using the long-table style translation technique with a

LOAD * INLINE [

Key, Locale, String

....

]

table and the =Only({Key=Foo} String) Expression and an association between the translation a language selection table?

Can I make Qlikview Store duplicate field entries twice or more?

topic Translation with FieldValue, FieldIndex fails for duplicate strings in QlikView

Translation with FieldValue, FieldIndex fails for duplicate strings