dual field

[Anonymous]

Hi

Is it possible to combine 2 text values within one dual field?

I have got a resident table with two fields 'RussianMedia', 'English Media'.

Is it possible on the backfront to create a dual field 'Media' which has both Russian and a corresponding English value (instead of the two fields)?

How can I refer to it on the forefront?

Thank you in advance,

Larisa

[maximiliano_vel]

Please post some example so that we can see what is your expected result...

Regards

[marcus_sommer · Accepted solution]

I don't think so. Dual() contains a numeric value and it's string-representation like:

dual(string, numeric)

If you want match both values into one field it would be better to concat both like:

'russian value' & '|' & 'englisch value' as match

and grab then the needed value with subfield(match, '|', 1).

- Marcus

[Anonymous]

It's a nice idea. Thenk you!

[swuehl]

Seems like you want to create something in the context of a multi-language application, right?

Then you might be interested in e.g.

Handling Multiple Languages‌

How to Handle Multi-Language Translations in QlikView.zip‌

Multi Language Dashboard implementation

[Anonymous]

Thank you!