topic Regarding values % in QlikView https://community.qlik.com/t5/QlikView/Regarding-values/m-p/945961#M325865 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have 2 tables Tab1,Tab2</P><P>tab1:</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">devA</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">devB</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">c</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">d</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">e</TD></TR></TBODY></TABLE><P></P><P>Tab2:</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"><STRONG>prodA</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">prodB</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">c</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">d</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">f</TD></TR></TBODY></TABLE><P></P><P>i want Values Match % in both fields in both fields</P><P>o/p like this:</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">dev</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">prod</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Match%</TH></TR><TR><TD style="padding: 2px;">devA</TD><TD style="padding: 2px;">prodA</TD><TD style="padding: 2px;">90% </TD></TR><TR><TD style="padding: 2px;">devB</TD><TD style="padding: 2px;">prodB</TD><TD style="padding: 2px;">90%</TD></TR></TBODY></TABLE><P></P><P>how to achive the match values % in fields?</P><P></P><P>Regards,</P><P>kd</P></BODY></HTML> Fri, 09 Oct 2015 12:10:37 GMT d_koti24 2015-10-09T12:10:37Z Regarding values % https://community.qlik.com/t5/QlikView/Regarding-values/m-p/945961#M325865 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have 2 tables Tab1,Tab2</P><P>tab1:</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">devA</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">devB</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">c</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">d</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">e</TD></TR></TBODY></TABLE><P></P><P>Tab2:</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"><STRONG>prodA</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">prodB</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">c</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">d</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">f</TD></TR></TBODY></TABLE><P></P><P>i want Values Match % in both fields in both fields</P><P>o/p like this:</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">dev</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">prod</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Match%</TH></TR><TR><TD style="padding: 2px;">devA</TD><TD style="padding: 2px;">prodA</TD><TD style="padding: 2px;">90% </TD></TR><TR><TD style="padding: 2px;">devB</TD><TD style="padding: 2px;">prodB</TD><TD style="padding: 2px;">90%</TD></TR></TBODY></TABLE><P></P><P>how to achive the match values % in fields?</P><P></P><P>Regards,</P><P>kd</P></BODY></HTML> Fri, 09 Oct 2015 12:10:37 GMT https://community.qlik.com/t5/QlikView/Regarding-values/m-p/945961#M325865 d_koti24 2015-10-09T12:10:37Z Re: Regarding values % https://community.qlik.com/t5/QlikView/Regarding-values/m-p/945962#M325866 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Maybe something like this:</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101551_Capture.PNG" style="height: auto;" /></P><P>Although, the true percentage of the match is 80% for both:</P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/101576_Capture.PNG" style="height: auto;" /></P><P>Hope this helps.</P></BODY></HTML> Fri, 09 Oct 2015 13:31:53 GMT https://community.qlik.com/t5/QlikView/Regarding-values/m-p/945962#M325866 sinanozdemir 2015-10-09T13:31:53Z