topic Re: Connecting Data to multiple columns in QlikView https://community.qlik.com/t5/QlikView/Connecting-Data-to-multiple-columns/m-p/394695#M147190 <HTML><HEAD></HEAD><BODY><P>It may make the most sense to simply create a table that links Leadr to SeminarID. </P><P></P><P><SPAN style="font-family: 'courier new', courier;">SeminarLeaderLink:</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD SeminarID, Leader1 as Leader</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">RESIDENT Seminar where len(Leader1)&gt;0;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD SeminarID, Leader2 as Leader</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">RESIDENT Seminar where len(Leader2)&gt;0;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD SeminarID, Leader3 as Leader</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">RESIDENT Seminar where len(Leader3)&gt;0;</SPAN></P><P></P><P>See attached.</P><P></P><P>-Rob</P></BODY></HTML> Fri, 30 Nov 2012 23:17:06 GMT rwunderlich 2012-11-30T23:17:06Z Connecting Data to multiple columns https://community.qlik.com/t5/QlikView/Connecting-Data-to-multiple-columns/m-p/394693#M147188 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Hi,</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">I want to select "Hans" in Leader.</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">If selected, all possible Seminars shoud be selected too, where "Hans" could be in Leader1, Leader2 or Leader3.</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">How?</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Regards</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Michael</P></BODY></HTML> Fri, 30 Nov 2012 14:14:26 GMT https://community.qlik.com/t5/QlikView/Connecting-Data-to-multiple-columns/m-p/394693#M147188 2012-11-30T14:14:26Z Re: Connecting Data to multiple columns https://community.qlik.com/t5/QlikView/Connecting-Data-to-multiple-columns/m-p/394694#M147189 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P></P><P>Use trigger concept</P><P></P><P> Document properties-&gt;trigger</P><P></P><P>PFA</P><P></P><P>Hope it helps</P></BODY></HTML> Fri, 30 Nov 2012 14:27:39 GMT https://community.qlik.com/t5/QlikView/Connecting-Data-to-multiple-columns/m-p/394694#M147189 MayilVahanan 2012-11-30T14:27:39Z Re: Connecting Data to multiple columns https://community.qlik.com/t5/QlikView/Connecting-Data-to-multiple-columns/m-p/394695#M147190 <HTML><HEAD></HEAD><BODY><P>It may make the most sense to simply create a table that links Leadr to SeminarID. </P><P></P><P><SPAN style="font-family: 'courier new', courier;">SeminarLeaderLink:</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD SeminarID, Leader1 as Leader</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">RESIDENT Seminar where len(Leader1)&gt;0;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD SeminarID, Leader2 as Leader</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">RESIDENT Seminar where len(Leader2)&gt;0;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD SeminarID, Leader3 as Leader</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">RESIDENT Seminar where len(Leader3)&gt;0;</SPAN></P><P></P><P>See attached.</P><P></P><P>-Rob</P></BODY></HTML> Fri, 30 Nov 2012 23:17:06 GMT https://community.qlik.com/t5/QlikView/Connecting-Data-to-multiple-columns/m-p/394695#M147190 rwunderlich 2012-11-30T23:17:06Z