topic Re: Script question: How to create a field with values based on another field in the same table? in QlikView https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58752#M606337 <HTML><HEAD></HEAD><BODY><P>Hi Michael,</P><P></P><P>I think its possible with If statement,but you may need to hard code the country name.</P><P></P><P>If (Country = 'UK' or Country = 'US' or Country = 'Australia',Country) as Country2</P><P></P><P>Regards,</P><P>Binu</P></BODY></HTML> Tue, 06 Mar 2018 23:22:29 GMT binujose1982 2018-03-06T23:22:29Z Script question: How to create a field with values based on another field in the same table? https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58748#M606333 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following field:</P><P></P><P>Country:</P><P>Australia</P><P>Brazil</P><P>China</P><P>France</P><P>UK</P><P>US</P><P></P><P>From the country field above I want to create a Country2 field.</P><P></P><P>Country2 field values should be:</P><P>Australia</P><P>UK</P><P>US</P><P></P><P>How can I create this field most efficiently please in the script?</P></BODY></HTML> Tue, 06 Mar 2018 14:33:41 GMT https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58748#M606333 mwallman 2018-03-06T14:33:41Z Re: Script question: How to create a field with values based on another field in the same table? https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58749#M606334 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>ok for the second field Country2, but the question here is how you want it to be linked to the first field ?</P></BODY></HTML> Tue, 06 Mar 2018 14:40:24 GMT https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58749#M606334 YoussefBelloum 2018-03-06T14:40:24Z Re: Script question: How to create a field with values based on another field in the same table? https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58750#M606335 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Both of the fields will be in the same table.</P><P></P><P>I just want Australia, UK, US for Country2 if they are present in the Country field.</P></BODY></HTML> Tue, 06 Mar 2018 14:56:09 GMT https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58750#M606335 mwallman 2018-03-06T14:56:09Z Re: Script question: How to create a field with values based on another field in the same table? https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58751#M606336 <HTML><HEAD></HEAD><BODY><P>why?</P></BODY></HTML> Tue, 06 Mar 2018 22:00:59 GMT https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58751#M606336 MarcoWedel 2018-03-06T22:00:59Z Re: Script question: How to create a field with values based on another field in the same table? https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58752#M606337 <HTML><HEAD></HEAD><BODY><P>Hi Michael,</P><P></P><P>I think its possible with If statement,but you may need to hard code the country name.</P><P></P><P>If (Country = 'UK' or Country = 'US' or Country = 'Australia',Country) as Country2</P><P></P><P>Regards,</P><P>Binu</P></BODY></HTML> Tue, 06 Mar 2018 23:22:29 GMT https://community.qlik.com/t5/QlikView/Script-question-How-to-create-a-field-with-values-based-on/m-p/58752#M606337 binujose1982 2018-03-06T23:22:29Z