topic Re: How to change values in a column? in QlikView https://community.qlik.com/t5/QlikView/How-to-change-values-in-a-column/m-p/1134260#M916431 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>If(WildMatch(Fruit, '*Apple*'), 'Tom', Owner) as Owner</STRONG></P></BODY></HTML> Thu, 12 May 2016 16:49:17 GMT sunny_talwar 2016-05-12T16:49:17Z How to change values in a column? https://community.qlik.com/t5/QlikView/How-to-change-values-in-a-column/m-p/1134259#M916430 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to change value in "Owner" column to Tom where Fruit contains "Apple". How can I do it? Thanks!</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 180px;"><TBODY><TR><TD height="20" style="border: 0px white; border-image: none; background-color: #1f4e78;" width="116"><STRONG style="color: #ffffff; font-size: 12pt; font-family: Calibri;">Fruit</STRONG></TD><TD style="border: 0px white; border-image: none; background-color: #1f4e78;" width="64"><STRONG style="color: #ffffff; font-size: 12pt; font-family: Calibri;">Owner</STRONG></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Green Apple</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Sam</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Red Apple</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Linda</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Green Kiwi</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Nancy</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Yellow Banana</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mary</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Yellow Pineapple</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">John</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Red Strawberry</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mary</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-change-values-in-a-column/m-p/1134259#M916430 posywang 2020-11-25T16:16:04Z Re: How to change values in a column? https://community.qlik.com/t5/QlikView/How-to-change-values-in-a-column/m-p/1134260#M916431 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>If(WildMatch(Fruit, '*Apple*'), 'Tom', Owner) as Owner</STRONG></P></BODY></HTML> Thu, 12 May 2016 16:49:17 GMT https://community.qlik.com/t5/QlikView/How-to-change-values-in-a-column/m-p/1134260#M916431 sunny_talwar 2016-05-12T16:49:17Z Re: How to change values in a column? https://community.qlik.com/t5/QlikView/How-to-change-values-in-a-column/m-p/1134261#M916432 <HTML><HEAD></HEAD><BODY><P>Or this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If(Index(Fruit, 'Apple'), 'Tom', Owner) as Owner</STRONG></P></BODY></HTML> Thu, 12 May 2016 16:49:37 GMT https://community.qlik.com/t5/QlikView/How-to-change-values-in-a-column/m-p/1134261#M916432 sunny_talwar 2016-05-12T16:49:37Z