topic Re: Append two translated values to one listbox in QlikView

Append two translated values to one listbox

Wed, 16 Jul 2014 09:40:43 GMT

Hi all,

I have two translated texts that (index 1, 2, in an Excel table) I would like to add into one listbox

The texts are obtained by those formular

= Only({< Index={1}>} upper( [$(=vDataLanguage)])) ---- TEXT 1

= Only({< Index={2}>} upper( [$(=vDataLanguage)])) ---- TEXT 2

Which expression should I create to have both values displayed in the same list box

(Listbox)

TEXT1

TEXT2

Thank you

Re: Append two translated values to one listbox

simondachstr — Wed, 16 Jul 2014 09:42:36 GMT

You should append (concatenate) them in the script or at least create a Data Island consisting of the translated texts.

Re: Append two translated values to one listbox

Wed, 16 Jul 2014 09:55:03 GMT

I know it is feasible via script but I'd like to know if we can do it at design using expression.

I have the following table. Column "Detail per day" is displayed in the interface. Is there a way to obtain the corresponding _choiceID when a value is selected in "Detail per day" ?

I heard about mapping table, but does it allow 3 columns instead of 2 as typical example ?

LOAD * INLINE [
    _Language, "Detail per day", _choiceID
    Français, oui, 'Y'
    Français, non, 'N'
    Deutsch, ja, 'Y'
    Deutsch, nein, 'N'
    English, yes, 'Y'
    English, no, 'N'
];