topic distinct text from 3 tables in QlikView https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356630#M132331 <HTML><HEAD></HEAD><BODY><P>This may not work depending on your data schema but try:</P><P></P><P>Concat(DISTINCT Qualification,',') </P><P></P><P>as your expression, with Tour as your dimension. </P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Wed, 18 Apr 2012 06:50:37 GMT Jason_Michaelides 2012-04-18T06:50:37Z distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356629#M132330 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a .qvw with 3 tables. For example:</P><P></P><P>Table1:</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"><SPAN style="color: #ffffff;"><STRONG>Tour<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Driver 1<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Qualification</STRONG></SPAN></TH></TR><TR><TD>10</TD><TD>Peter</TD><TD>A, B, C</TD></TR></TBODY></TABLE><P></P><P>Table2:</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"><SPAN style="color: #ffffff;"><STRONG>Tour<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Driver 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Qualification</STRONG></SPAN></TH></TR><TR><TD>10</TD><TD>Paul</TD><TD>C, D</TD></TR></TBODY></TABLE><P>Table3:</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"><SPAN style="color: #ffffff;"><STRONG>Tour<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Driver 3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Qualification</STRONG></SPAN></TH></TR><TR><TD>10</TD><TD>John</TD><TD>A, B</TD></TR></TBODY></TABLE><P></P><P>My Problem is:</P><P>When i select Tour 10, then i want to show in a listbox or a diagramm the result of Qualification from all Drivers</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"><SPAN style="color: #ffffff;"><STRONG>Tour<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Qualification</STRONG></SPAN></TH></TR><TR><TD>10</TD><TD>A, B, C, D</TD></TR></TBODY></TABLE><P></P><P>Can anybody help me?</P><P></P><P>Thanks</P><P></P><P>Chris</P></BODY></HTML> Wed, 18 Apr 2012 06:46:56 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356629#M132330 wunderch 2012-04-18T06:46:56Z distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356630#M132331 <HTML><HEAD></HEAD><BODY><P>This may not work depending on your data schema but try:</P><P></P><P>Concat(DISTINCT Qualification,',') </P><P></P><P>as your expression, with Tour as your dimension. </P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Wed, 18 Apr 2012 06:50:37 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356630#M132331 Jason_Michaelides 2012-04-18T06:50:37Z distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356631#M132332 <HTML><HEAD></HEAD><BODY><P> it wont work without 'total' qualifer</P><P></P><P>Vitul</P></BODY></HTML> Wed, 18 Apr 2012 07:26:36 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356631#M132332 2012-04-18T07:26:36Z distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356632#M132333 <HTML><HEAD></HEAD><BODY><P>Shouldn't need TOTAL if Tour is the only dimension. </P></BODY></HTML> Wed, 18 Apr 2012 07:49:17 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356632#M132333 Jason_Michaelides 2012-04-18T07:49:17Z distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356633#M132334 <HTML><HEAD></HEAD><BODY><P> its not working even tour is the only dimension..........</P><P></P><P>Vitul</P></BODY></HTML> Wed, 18 Apr 2012 08:50:43 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356633#M132334 2012-04-18T08:50:43Z distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356634#M132335 <HTML><HEAD></HEAD><BODY><P>Hi Jason,</P><P></P><P>do you also have a solution for this constellation:</P><P></P><P>1 Table:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="1093"><TBODY><TR><TD class="xl65" height="20" width="46">Tour</TD><TD class="xl65" style="border-left: medium none;" width="88">Driver1</TD><TD class="xl65" style="border-left: medium none;" width="95">Qual1. Driver1</TD><TD class="xl65" style="border-left: medium none;" width="95">Qual2. Driver1</TD><TD class="xl65" style="border-left: medium none;" width="95">Qual.3 Driver1</TD><TD class="xl65" style="border-left: medium none;" width="52">Driver2</TD><TD class="xl65" style="border-left: medium none;" width="95">Qual1. Driver1</TD><TD class="xl65" style="border-left: medium none;" width="95">Qual2. Driver1</TD><TD class="xl65" style="border-left: medium none;" width="95">Qual.3 Driver1</TD><TD class="xl65" style="border-left: medium none;" width="52">Driver3</TD><TD class="xl65" style="border-left: medium none;" width="95">Qual1. Driver1</TD><TD class="xl65" style="border-left: medium none;" width="95">Qual2. Driver1</TD><TD class="xl65" style="border-left: medium none;" width="95">Qual.3 Driver1</TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">10</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">Peter</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">A</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">B</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">C</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">Paul</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">C</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">D</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;"> </TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">John</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">A</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">B</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;"> </TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20">Result</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD class="xl65" height="20">Tour</TD><TD class="xl65" style="border-left: medium none;">Qualifikation</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD class="xl66" height="20" style="border-top: medium none;">10</TD><TD class="xl65" style="border-top: medium none; border-left: medium none;">A, B, C, D</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>Thanks</P><P></P><P>Chris</P></BODY></HTML> Wed, 18 Apr 2012 08:52:00 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356634#M132335 wunderch 2012-04-18T08:52:00Z distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356635#M132336 <HTML><HEAD></HEAD><BODY><P> its working...i had some problem with my data...</P><P>sry....</P><P></P><P>Vitul</P></BODY></HTML> Wed, 18 Apr 2012 08:59:22 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356635#M132336 2012-04-18T08:59:22Z distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356636#M132337 <HTML><HEAD></HEAD><BODY><P>How does the actual data look, Chris?&nbsp; Can you post a sample?</P></BODY></HTML> Wed, 18 Apr 2012 10:23:05 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356636#M132337 Jason_Michaelides 2012-04-18T10:23:05Z Re: distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356637#M132338 <HTML><HEAD></HEAD><BODY><P>Here is a example.</P><P></P><P>TUTURN = Tour</P><P>TUFHR1 = Driver1</P><P>TUFHR2 = Driver2</P><P>TUFHR3 = Driver3</P><P>TUFHR1_ZQUA1 = Driver1_Qualification1</P><P>.</P><P>.</P><P>.</P><P></P><P>Result for TUTURN=1686386</P><P>TUTURN Qualification</P><P>1686386 KÜCHEN 1, KÜCHEN 2, KÜCHEN 3, MÖBEL 3, ELEKTRO </P></BODY></HTML> Wed, 18 Apr 2012 12:10:09 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356637#M132338 wunderch 2012-04-18T12:10:09Z distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356638#M132339 <HTML><HEAD></HEAD><BODY><P>OK - got it.&nbsp; You need to use Crosstable().&nbsp; Please post your 2 QVD files:</P><P></P><P>ZQUA_TESTCW.qvd and TOUR_Ebene2_2012.qvd and I'll show you how.</P><P></P><P>Cheers,</P><P></P><P>Jason</P></BODY></HTML> Wed, 18 Apr 2012 14:26:01 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356638#M132339 Jason_Michaelides 2012-04-18T14:26:01Z Re: distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356639#M132340 <HTML><HEAD></HEAD><BODY><P>GREAT!!</P><P></P><P>Here are the two .qvd.</P><P></P><P>ZQUA_TESTCW.qvd and TOUR_Ebene2.qvd</P></BODY></HTML> Wed, 18 Apr 2012 14:38:18 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356639#M132340 wunderch 2012-04-18T14:38:18Z Re: distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356640#M132341 <HTML><HEAD></HEAD><BODY><P>Sorry for the delay - my internet went down!</P><P></P><P>Here you go - see attached.&nbsp; I have commented the script so hopefully you'll follow the logic.</P><P></P><P>Hope it helps,</P><P></P><P>Jason</P></BODY></HTML> Wed, 18 Apr 2012 16:02:28 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356640#M132341 Jason_Michaelides 2012-04-18T16:02:28Z Re: distinct text from 3 tables https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356641#M132342 <HTML><HEAD></HEAD><BODY><P>Hi Jason,</P><P></P><P>no Problem! </P><P></P><P>I could follow your comments and it works fantastic.</P><P></P><P>Thanks for your quick help!!</P><P></P><P>Chris</P></BODY></HTML> Thu, 19 Apr 2012 10:55:01 GMT https://community.qlik.com/t5/QlikView/distinct-text-from-3-tables/m-p/356641#M132342 wunderch 2012-04-19T10:55:01Z