Qlikview

[Sureshbabukapu]

Hai all, 

My self suresh iam a qlik beginner, 

Logic Item #1: Please create new logic based field in the VNDR_SUST Table. New Field: DIVERSE Logic: If any of the following attributes = “Y”, then DIVERSE = “Y” ABILITY_ONE ALASKAN_NATIVE DBE DISABLED DVBE EDWOSB GLBT HBCU HUBZONE MBE MWBE SB8A SDB VBE WBE WOSB

Note:can anyone please explain about above requirement I tried multiple ways but i didn't understand 

[anat · Accepted solution]

if(ABILITY_ONE='Y' or  ALASKAN_NATIVE='Y' or  DBE='Y' or  DISABLED='Y' or  DVBE='Y' or  EDWOSB='Y' or  GLBT='Y' or  HBCU='Y' or  HUBZONE='Y' or  MBE='Y' or  MWBE='Y' or  SB8A='Y' or  SDB='Y' or  VBE='Y' or  WBE='Y' or  WOSB='Y' ,'Y') as DIVERSE

any of the above field value is 'Y' then make it 'Y'.

[Sureshbabukapu]

Thank sir that's working

And is there any another way with same condition