Qlikview

[Sureshbabukapu]

Hai all, 

My self suresh and i am new to qlikview, 

My requirement:

Logic Item #2: Please create new logic based field in the VDRITM_SUST Table. New Field: SUSTAINABLE Logic: If any of the following attributes = “Y”, then SUSTAINABLE = “Y” AASHE_STARS AGA_GRASS_FED AMR_HUMANE_CERT AMR_HUMMANE_CER_CAGE_FREE AQUA_CULTURE_STWD_COUNCIL B_CORP_CERT BAP CAGE_FREE CERT_HUMANE_RAISE_HANDLE CERT_RESP_ANTIBITOIC_USE COMPOST_PKG CONVSERV_ALLI_SEAFOOD_SOLUTIONS FAIR_FOR_LIFE FAIR_TRADE GLOBAL_ANIMAL_PRTNRSHP GROUP_HOUSED HEALTHCARE_WOUT_HARM MARINE_STWD_CNCL_BLUE_LABEL MARINE_STWD_COUNCIL MBE_MANUFAC_CERT MEETS_ARAMARK_COMMITMENT MONTEREY_BAY_SEAFOOD_WATCH NAE NON_GMO_VERIFY PLANT_BASED RAINFOREST_ALLIANCE_CERT SALMON_SAFE_CERT SB_COFFEE_FARMER_EQUITY SCS SUSTAIN_INST_AFFIRMED USDA_CERT_ORGNAIC WBE_MANUFAC_CERT

Note:I don't understand this requirement can anyone please help me with this... Explain about above requirement

[MarcoWedel]

The first step to understanding this requirement could be to properly format the requirement text you just posted so you can identify the different sections that are described in there ...

[krishna_2644]

I believe this is what you looking for. else attach a mocked up data.

PFA for code with mocked up data.

[anat]

source Table Name is VDRITM_SUST,based on the below logic you need to derive new field SUSTAINABLE 

logic: 

if(
AASHE_STARS='Y' or AGA_GRASS_FED='Y' or AMR_HUMANE_CERT='Y' or AMR_HUMMANE_CER_CAGE_FREE='Y' or AQUA_CULTURE_STWD_COUNCIL='Y' or
B_CORP_CERT='Y' or BAP CAGE_FREE='Y' or CERT_HUMANE_RAISE_HANDLE='Y' or CERT_RESP_ANTIBITOIC_USE='Y' or COMPOST_PKG='Y' or
CONVSERV_ALLI_SEAFOOD_SOLUTIONS='Y' or FAIR_FOR_LIFE='Y' or FAIR_TRADE='Y' or GLOBAL_ANIMAL_PRTNRSHP='Y' or GROUP_HOUSED='Y' or
HEALTHCARE_WOUT_HARM='Y' or MARINE_STWD_CNCL_BLUE_LABEL='Y' or MARINE_STWD_COUNCIL='Y' or MBE_MANUFAC_CERT='Y' or MEETS_ARAMARK_COMMITMENT='Y' or
MONTEREY_BAY_SEAFOOD_WATCH='Y' or NAE NON_GMO_VERIFY='Y' or PLANT_BASED='Y' or RAINFOREST_ALLIANCE_CERT='Y' or SALMON_SAFE_CERT='Y' or
SB_COFFEE_FARMER_EQUITY='Y' or SCS='Y' or SUSTAIN_INST_AFFIRMED='Y' or USDA_CERT_ORGNAIC='Y' or WBE_MANUFAC_CERT='Y' ,'Y') as SUSTAINABLE