Translation Value Field

[Anonymous]

Hi,

I want translate some value of fied

i have Field with this values :

F1:

     abc,

     ddf,

     cdd,

     trr,

     rrr

and if i use Multilanguage i want have this

F1:

     TTT,

     FFF,

     cdd,

     trr,

     rrr

i want translate only abc to TTT and ddf to FFF

If you have any idee please share.

Best Regards,

Elmahfodu

[#2]

Hi,

Try

If(F1 = 'abc','TTT',if(T1 = 'ddf','FFF',F1))

Rebeca

[#3]

Hi ,

      Try to use Mapping table like

Map:

mapping load * inline

[

FiledValue , ReturnValue

abc , TTT

ddf , FFF

];

then use in the table like

ApplyMap('Map' , F1)

in the load

Please reply me for the same .

//Yusuf

[Anonymous]

Hi Rebeca,

Thanks for your answer but i have more value to translate i have 35 values

is there function in Qlikview to do that.

Best Regards,

Elmahfoud

[eddysanchez]

I don't know if I understand

You need to create a relation between:

F1:

     abc,

     ddf,

and

F2

     TTT,

     FFF,

If you have the relationship you can use =Only({<F1={abc}>}F2) for TTT

[Anonymous]

Hi All,

Thanks for your answer.

I solve my problem by this way in Edit Script i add constant 'EN' as Language in my First table having F1 and the second i add 'ES' as Language in second table having F2 finally i use concatenation

MyTable :

F1,

F2,

Language

from....

with

F1:

     abc,

     ddf,

     cdd,

     trr,

     rrr

F2:

F1:

     TTT,

     FFF,

     cdd,

     trr,

     rrr

and Language:

                    EN,

                    ES

Best Regards,

elmahfoud