First unique value from different Fields

[#1]

Hi Qlikview Friends:

I have four different fields, but want to create a new field with the value from the first available field,

example as below:

Field1          Field2          Field3          Field4          Newfield(Required)

-                    -                    A               B                    A

B                   -                    C               D                   B

-                    B                   D              E                    B 

Appreciate your help in advance.

thanks

Kumar

[#2 · Accepted solution]

Hi Kumar,

Please see the script in the attached QVW.

Thanks,

Shruthi

[#3]

Hi Thank you, appreciate the help Shruthi