topic If else or in QlikView

If else or

Wed, 02 Mar 2011 14:23:46 GMT

I need your help.

I have field WOST tha can has four possible values : 'R' or "D" or "C" or "L".

R = Release

D= Complete

C= Delete

L = Close

How can translate into the script this instruction :

if WOSTS = 'R' then MYFILD = 'Release' or WOST= 'D' then MYFILD = 'Complete' or WOST= 'C' then MYFILD = 'Delete' or .....

thank you

If else or

Miguel_Angel_Baeyens — Wed, 02 Mar 2011 14:27:04 GMT

Hello,

Use a mapping table:

CodeNameMap:MAPPING LOAD * INLINE [ CODE, DESCRIPTIONR, ReleaseD, CompleteD, DeleteL, Close]; // or whatever the source is Table:LOAD *, ApplyMap('CodeNameMap', WOST) AS MYFILDFROM Table;

Hope that helps

If else or

Wed, 02 Mar 2011 14:52:22 GMT

GREAT t!!!
Many thanks

Regards