topic Re: Translation Value Field in QlikView

Translation Value Field

Anonymous — Thu, 18 Apr 2013 14:06:29 GMT

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

Re: Translation Value Field

Thu, 18 Apr 2013 14:26:17 GMT

Hi,

Try

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

Rebeca

Re: Translation Value Field

Thu, 18 Apr 2013 14:53:47 GMT

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

Re: Translation Value Field

Anonymous — Thu, 18 Apr 2013 14:54:18 GMT

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

Re: Translation Value Field

eddysanchez — Thu, 18 Apr 2013 14:54:42 GMT

I don't know if I understand

You need to create a relation between:

F1:

abc,

ddf,

and

TTT,

FFF,

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

Re: Translation Value Field

Anonymous — Thu, 18 Apr 2013 16:45:21 GMT

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,

Best Regards,

elmahfoud