topic Re: How to compare two fields with character in QlikView https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80486#M778087 <HTML><HEAD></HEAD><BODY><P>Easy to achieve at back end (script side)</P></BODY></HTML> Mon, 09 Apr 2018 18:22:10 GMT MK_QSL 2018-04-09T18:22:10Z How to compare two fields with character https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80484#M778085 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>Is it possible to compare two fields with character and show the differences (i.e. with delimiter "|" in between the country name)?</P><P></P><P>I have two fields like this:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Current Country</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Previous Country</STRONG></TH></TR><TR><TD style="padding: 2px;">USA|Canada|France</TD><TD style="padding: 2px;">USA|Canada</TD></TR><TR><TD style="padding: 2px;">Germany|China</TD><TD style="padding: 2px;">China|Japan</TD></TR><TR><TD style="padding: 2px;">Korea|Russia</TD><TD style="padding: 2px;">Chile|Ireland</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to add two more fields for comparing current country and previous country to see if there is any change (add / drop)</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Current Country</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Previous Country</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Current Country: Add</STRONG></P><P><STRONG>(Compare with Previous Country)</STRONG></P><P></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Current Country: Drop</STRONG></P><P><STRONG>(Compare with Previous Country)</STRONG></P></TH></TR><TR><TD style="padding: 2px;">USA|Canada|France</TD><TD style="padding: 2px;">USA|Canada</TD><TD style="padding: 2px;">France</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Germany|China</TD><TD style="padding: 2px;">China|Japan</TD><TD style="padding: 2px;">Germany</TD><TD style="padding: 2px;">Japan</TD></TR><TR><TD style="padding: 2px;">Korea|Russia</TD><TD style="padding: 2px;">Chile|Ireland</TD><TD style="padding: 2px;">Korea|Russia</TD><TD style="padding: 2px;">Chile|Ireland</TD></TR><TR><TD style="padding: 2px;">England</TD><TD style="padding: 2px;">Singapore|Italy|Holland</TD><TD style="padding: 2px;">England</TD><TD style="padding: 2px;">Singapore|Italy|Holland</TD></TR></TBODY></TABLE><P></P><P></P><P>Regards</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80484#M778085 Anonymous 2020-11-25T16:16:04Z Re: How to compare two fields with character https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80485#M778086 <HTML><HEAD></HEAD><BODY><P>Is this needed directly on the front end of the application?</P></BODY></HTML> Mon, 09 Apr 2018 18:21:18 GMT https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80485#M778086 sunny_talwar 2018-04-09T18:21:18Z Re: How to compare two fields with character https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80486#M778087 <HTML><HEAD></HEAD><BODY><P>Easy to achieve at back end (script side)</P></BODY></HTML> Mon, 09 Apr 2018 18:22:10 GMT https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80486#M778087 MK_QSL 2018-04-09T18:22:10Z Re: How to compare two fields with character https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80487#M778088 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>But how? Can you share the script please?</P><P></P><P>Regards</P></BODY></HTML> Tue, 10 Apr 2018 01:26:20 GMT https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80487#M778088 Anonymous 2018-04-10T01:26:20Z Re: How to compare two fields with character https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80488#M778089 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Yup, any idea?</P></BODY></HTML> Tue, 10 Apr 2018 01:27:12 GMT https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80488#M778089 Anonymous 2018-04-10T01:27:12Z Re: How to compare two fields with character https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80489#M778090 <HTML><HEAD></HEAD><BODY><P>Hi Peter,</P><P></P><P>Please see the attachment, hope that's what you want.</P><P></P><P><IMG alt="How to compare two fields with character.PNG" class="jive-image image-1" src="/legacyfs/online/199028_How to compare two fields with character.PNG" style="height: 226px; width: 620px;" /></P><P></P><P>Thanks.</P><P>Aiolos</P></BODY></HTML> Tue, 10 Apr 2018 06:49:36 GMT https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80489#M778090 uacg0009 2018-04-10T06:49:36Z Re: How to compare two fields with character https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80490#M778091 <HTML><HEAD></HEAD><BODY><P>Hi Aiolos,</P><P></P><P>Thanks, it works</P><P></P><P>Regards</P></BODY></HTML> Wed, 11 Apr 2018 03:32:45 GMT https://community.qlik.com/t5/QlikView/How-to-compare-two-fields-with-character/m-p/80490#M778091 Anonymous 2018-04-11T03:32:45Z