topic Re: compare two array QlikSense in QlikView https://community.qlik.com/t5/QlikView/compare-two-array-QlikSense/m-p/1157378#M632193 <HTML><HEAD></HEAD><BODY><P>Not sure the exact need but it can be done through scripting, see the sample qvf attached -</P></BODY></HTML> Thu, 09 Jun 2016 08:40:20 GMT Digvijay_Singh 2016-06-09T08:40:20Z compare two array QlikSense https://community.qlik.com/t5/QlikView/compare-two-array-QlikSense/m-p/1157377#M632192 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Hi everyone,</SPAN></P><P></P><P>Is it possible to compare two array like excel in QlikSense?</P><P></P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid rgb(0, 0, 0); width: 146px; height: 56px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Group</STRONG></TH></TR><TR><TD style="padding: 2px;">Group A1</TD></TR><TR><TD style="padding: 2px;">Group B1</TD></TR><TR><TD style="padding: 2px;">Group A2</TD></TR><TR><TD>Group B2</TD></TR></TBODY></TABLE><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid rgb(0, 0, 0); width: 148px; height: 104px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Zone</STRONG></TH></TR><TR><TD style="padding: 2px;">Zone 1</TD></TR><TR><TD style="padding: 2px;">Zone 2</TD></TR></TBODY></TABLE><P></P><P>And merge these 2 array :</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Zone</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Group</TH></TR><TR><TD style="padding: 2px;">Zone 1</TD><TD style="padding: 2px;"><P>Group A1</P><P>Group A2</P></TD></TR><TR><TD style="padding: 2px;">Zone 2</TD><TD style="padding: 2px;"><P>Group B1</P><P>Group B2</P></TD></TR></TBODY></TABLE><P></P><P>Thanks for your help ! </P><P></P><P>Regards</P></BODY></HTML> Thu, 09 Jun 2016 07:48:27 GMT https://community.qlik.com/t5/QlikView/compare-two-array-QlikSense/m-p/1157377#M632192 2016-06-09T07:48:27Z Re: compare two array QlikSense https://community.qlik.com/t5/QlikView/compare-two-array-QlikSense/m-p/1157378#M632193 <HTML><HEAD></HEAD><BODY><P>Not sure the exact need but it can be done through scripting, see the sample qvf attached -</P></BODY></HTML> Thu, 09 Jun 2016 08:40:20 GMT https://community.qlik.com/t5/QlikView/compare-two-array-QlikSense/m-p/1157378#M632193 Digvijay_Singh 2016-06-09T08:40:20Z