topic dual field in QlikView

dual field

Anonymous — Sat, 15 Aug 2015 17:16:49 GMT

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 — Sat, 15 Aug 2015 17:22:07 GMT

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

Regards

marcus_sommer — Sat, 15 Aug 2015 18:09:43 GMT

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 — Sun, 16 Aug 2015 10:31:13 GMT

It's a nice idea. Thenk you!

swuehl — Sun, 16 Aug 2015 11:56:13 GMT

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

Then you might be interested in e.g.

Anonymous — Sun, 16 Aug 2015 16:40:28 GMT

Thank you!