Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

If else or

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

2 Replies
Highlighted

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

Highlighted
Not applicable

GREAT t!!!
Many thanks

Regards