topic create mulitbox with distinct values in QlikView https://community.qlik.com/t5/QlikView/create-mulitbox-with-distinct-values/m-p/441288#M489596 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am new to Qlikview and struggle with a simple task. I imported a csv-file that looks like this:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff;">Client</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff;">ID</STRONG></TH></TR><TR><TD>x</TD><TD>a</TD></TR><TR><TD>x</TD><TD>b</TD></TR><TR><TD>x</TD><TD>c</TD></TR><TR><TD>y</TD><TD>d</TD></TR><TR><TD>y</TD><TD>e</TD></TR><TR><TD>z</TD><TD>p</TD></TR></TBODY></TABLE><P></P><P></P><P>Now I want to create a Multibox that lists all clients with at least two (unique) ids like:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff;">Client</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff;">ID</STRONG></TH></TR><TR><TD>x</TD><TD>List(a,b,c)</TD></TR><TR><TD>y</TD><TD>List(d,e)</TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">Any help is appreciated.</SPAN></P></BODY></HTML> Fri, 16 Nov 2012 14:10:13 GMT 2012-11-16T14:10:13Z create mulitbox with distinct values https://community.qlik.com/t5/QlikView/create-mulitbox-with-distinct-values/m-p/441288#M489596 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am new to Qlikview and struggle with a simple task. I imported a csv-file that looks like this:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff;">Client</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff;">ID</STRONG></TH></TR><TR><TD>x</TD><TD>a</TD></TR><TR><TD>x</TD><TD>b</TD></TR><TR><TD>x</TD><TD>c</TD></TR><TR><TD>y</TD><TD>d</TD></TR><TR><TD>y</TD><TD>e</TD></TR><TR><TD>z</TD><TD>p</TD></TR></TBODY></TABLE><P></P><P></P><P>Now I want to create a Multibox that lists all clients with at least two (unique) ids like:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff;">Client</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff;">ID</STRONG></TH></TR><TR><TD>x</TD><TD>List(a,b,c)</TD></TR><TR><TD>y</TD><TD>List(d,e)</TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">Any help is appreciated.</SPAN></P></BODY></HTML> Fri, 16 Nov 2012 14:10:13 GMT https://community.qlik.com/t5/QlikView/create-mulitbox-with-distinct-values/m-p/441288#M489596 2012-11-16T14:10:13Z Re: create mulitbox with distinct values https://community.qlik.com/t5/QlikView/create-mulitbox-with-distinct-values/m-p/441289#M489597 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA</P><P></P><P>In listbox, you can add expression like in attached file</P><P></P><P>Hope it helps</P></BODY></HTML> Fri, 16 Nov 2012 14:27:10 GMT https://community.qlik.com/t5/QlikView/create-mulitbox-with-distinct-values/m-p/441289#M489597 MayilVahanan 2012-11-16T14:27:10Z