how to get field

[bsbernabe]

Hello There,

i have concern regarding this below i don't know how o do this.

=IF([Field1]='SUP' get this field [Field3])

=IF([Field4]='MGR' get this field [Field4])

Best Regards,

Bing

[qlikwiz123]

Could you share your solution and mark this thread as 'Resolved' after that?