https://community.qlik.com/t5/App-Development/Qlik-beginner/m-p/1883136#M72706 <P>Hai all,&nbsp;</P> <P>My self suresh iam a student and qlik beginner,&nbsp;</P> <P>My task:</P> <P>Please create new logic based field in the VDRITM_SUST Table.</P> <P>&nbsp;</P> <P>New Field: SUSTAINABLE</P> <P>&nbsp;</P> <P>Logic: If any of the following attributes = “Y”, then SUSTAINABLE = “Y”</P> <P>AASHE_STARS<BR />AGA_GRASS_FED<BR />AMR_HUMANE_CERT<BR />AMR_HUMMANE_CER_CAGE_FREE<BR />AQUA_CULTURE_STWD_COUNCIL<BR />B_CORP_CERT<BR />BAP<BR />CAGE_FREE<BR />CERT_HUMANE_RAISE_HANDLE<BR />CERT_RESP_ANTIBITOIC_USE<BR />COMPOST_PKG<BR />CONVSERV_ALLI_SEAFOOD_SOLUTIONS<BR />FAIR_FOR_LIFE<BR />FAIR_TRADE<BR />GLOBAL_ANIMAL_PRTNRSHP<BR />GROUP_HOUSED<BR />HEALTHCARE_WOUT_HARM<BR />MARINE_STWD_CNCL_BLUE_LABEL<BR />MARINE_STWD_COUNCIL<BR />MBE_MANUFAC_CERT<BR />MEETS_ARAMARK_COMMITMENT<BR />MONTEREY_BAY_SEAFOOD_WATCH<BR />NAE<BR />NON_GMO_VERIFY<BR />PLANT_BASED<BR />RAINFOREST_ALLIANCE_CERT<BR />SALMON_SAFE_CERT<BR />SB_COFFEE_FARMER_EQUITY<BR />SCS<BR />SUSTAIN_INST_AFFIRMED<BR />USDA_CERT_ORGNAIC<BR />WBE_MANUFAC_CERT</P> <P>MEETS_ARAMARK_COMMITMENT</P> <P>&nbsp;</P> <P>HOW CAN I IMPLEMENT THIS PLEASE HELP ME</P> <P>Thanks,&nbsp;</P> <P>Suresh</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 20 Jan 2022 04:57:20 GMT Sureshbabukapu 2022-01-20T04:57:20Z https://community.qlik.com/t5/App-Development/Qlik-beginner/m-p/1883136#M72706 <P>Hai all,&nbsp;</P> <P>My self suresh iam a student and qlik beginner,&nbsp;</P> <P>My task:</P> <P>Please create new logic based field in the VDRITM_SUST Table.</P> <P>&nbsp;</P> <P>New Field: SUSTAINABLE</P> <P>&nbsp;</P> <P>Logic: If any of the following attributes = “Y”, then SUSTAINABLE = “Y”</P> <P>AASHE_STARS<BR />AGA_GRASS_FED<BR />AMR_HUMANE_CERT<BR />AMR_HUMMANE_CER_CAGE_FREE<BR />AQUA_CULTURE_STWD_COUNCIL<BR />B_CORP_CERT<BR />BAP<BR />CAGE_FREE<BR />CERT_HUMANE_RAISE_HANDLE<BR />CERT_RESP_ANTIBITOIC_USE<BR />COMPOST_PKG<BR />CONVSERV_ALLI_SEAFOOD_SOLUTIONS<BR />FAIR_FOR_LIFE<BR />FAIR_TRADE<BR />GLOBAL_ANIMAL_PRTNRSHP<BR />GROUP_HOUSED<BR />HEALTHCARE_WOUT_HARM<BR />MARINE_STWD_CNCL_BLUE_LABEL<BR />MARINE_STWD_COUNCIL<BR />MBE_MANUFAC_CERT<BR />MEETS_ARAMARK_COMMITMENT<BR />MONTEREY_BAY_SEAFOOD_WATCH<BR />NAE<BR />NON_GMO_VERIFY<BR />PLANT_BASED<BR />RAINFOREST_ALLIANCE_CERT<BR />SALMON_SAFE_CERT<BR />SB_COFFEE_FARMER_EQUITY<BR />SCS<BR />SUSTAIN_INST_AFFIRMED<BR />USDA_CERT_ORGNAIC<BR />WBE_MANUFAC_CERT</P> <P>MEETS_ARAMARK_COMMITMENT</P> <P>&nbsp;</P> <P>HOW CAN I IMPLEMENT THIS PLEASE HELP ME</P> <P>Thanks,&nbsp;</P> <P>Suresh</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 20 Jan 2022 04:57:20 GMT https://community.qlik.com/t5/App-Development/Qlik-beginner/m-p/1883136#M72706 Sureshbabukapu 2022-01-20T04:57:20Z https://community.qlik.com/t5/App-Development/Qlik-beginner/m-p/1883267#M72728 <P>Retirement is not clear what exactly you need to achieve ?&nbsp; elaborate more in detail.</P> <P>Vikas</P> Thu, 20 Jan 2022 10:15:34 GMT https://community.qlik.com/t5/App-Development/Qlik-beginner/m-p/1883267#M72728 vikasmahajan 2022-01-20T10:15:34Z https://community.qlik.com/t5/App-Development/Qlik-beginner/m-p/1883279#M72732 <P>if(substringcount(<SPAN>AASHE_STARS&amp;</SPAN><SPAN>AGA_GRASS_FED&amp;</SPAN><SPAN>AMR_HUMANE_CERT&amp;</SPAN><SPAN>AMR_HUMMANE_CER_CAGE_FREE&amp;...,'Y'),'Y','N') as Sustainable&nbsp;</SPAN></P> Thu, 20 Jan 2022 10:31:40 GMT https://community.qlik.com/t5/App-Development/Qlik-beginner/m-p/1883279#M72732 mikaelsc 2022-01-20T10:31:40Z