topic Re: need help in using inline properly in QlikView https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720957#M676983 <HTML><HEAD></HEAD><BODY><P>But you have to hard code the table and do the mapping load for the table Book.</P><P></P><P>Book:</P><P>Mapping LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Geography,Book</P><P>&nbsp;&nbsp;&nbsp; london,Austin</P><P>&nbsp;&nbsp;&nbsp; paris,Austin</P><P>&nbsp;&nbsp;&nbsp; newyork,Austin</P><P>&nbsp;&nbsp;&nbsp; denmark,Austin</P><P>&nbsp;&nbsp;&nbsp; holland,Jimmy<SPAN style="font-size: 10pt; line-height: 1.5em;">];</SPAN></P><P></P><P>Geography:</P><P>LOAD Geography,ApplyMap('Book',Geography) as Book;</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Geography</P><P>&nbsp;&nbsp;&nbsp; london</P><P>&nbsp;&nbsp;&nbsp; paris</P><P>&nbsp;&nbsp;&nbsp; newyork</P><P>&nbsp;&nbsp;&nbsp; denmark</P><P>&nbsp;&nbsp;&nbsp; holland];</P></BODY></HTML> Sat, 21 Jun 2014 13:16:39 GMT its_anandrjs 2014-06-21T13:16:39Z need help in using inline properly https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720952#M676977 <HTML><HEAD></HEAD><BODY><P>i have two tables</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="76" style="width: 116px; height: 76px; border: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>book</STRONG></TH></TR><TR><TD style="padding: 2px;">austin</TD></TR><TR><TD style="padding: 2px;">jimmy</TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="1" class="jiveBorder" style="width: 15.44%; height: 201px; border: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>geography</STRONG></TH></TR><TR><TD style="padding: 2px;">austin</TD></TR><TR><TD style="padding: 2px;">jimmy</TD></TR><TR><TD style="padding: 2px;">london</TD></TR><TR><TD style="padding: 2px;">paris</TD></TR><TR><TD style="padding: 2px;">new york</TD></TR><TR><TD style="padding: 2px;">denmark</TD></TR><TR><TD style="padding: 2px;">holland</TD></TR></TBODY></TABLE><P></P><P>now austin and jimmy does not actually come under geography but they are there in the table,</P><P></P><P>london, paris, newyork and denmark come under austin and holland come under jimmy. </P><P>now what i want to do is mapping between these two tables so that when i click austin from book table only london paris newyork and denmark should get selected from geography table and when i click jimmy only holland should be selected from geography table.</P></BODY></HTML> Sat, 21 Jun 2014 08:08:09 GMT https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720952#M676977 2014-06-21T08:08:09Z Re: need help in using inline properly https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720953#M676979 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use Inline table to map</P><P>BookAuthor:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Book</P><P>&nbsp;&nbsp;&nbsp; Austin</P><P>&nbsp;&nbsp;&nbsp; Jimmy</P><P>];</P><P></P><P>Book_Geography:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Book, Geography</P><P>&nbsp;&nbsp;&nbsp; Austin, london</P><P>&nbsp;&nbsp;&nbsp; Austin, paris</P><P>&nbsp;&nbsp;&nbsp; Austin, newyork</P><P>&nbsp;&nbsp;&nbsp; Austin, denmark</P><P>&nbsp;&nbsp;&nbsp; Jimmy, holland</P><P>];</P><P></P><P></P><P>Regards,</P></BODY></HTML> Sat, 21 Jun 2014 08:14:16 GMT https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720953#M676979 PrashantSangle 2014-06-21T08:14:16Z Re: need help in using inline properly https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720954#M676980 <HTML><HEAD></HEAD><BODY><P>Try to load your table like this way</P><P></P><P>Book:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Book</P><P>&nbsp;&nbsp;&nbsp; Austin</P><P>&nbsp;&nbsp;&nbsp; Jimmy</P><P>];</P><P></P><P>Geography:</P><P>LOAD If(Match(Geography,'london','paris','newyork','denmark'),'Austin',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(Match(Geography,'holland'),'Jimmy')) as Book,Geography; </P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Geography</P><P>&nbsp;&nbsp;&nbsp; london</P><P>&nbsp;&nbsp;&nbsp; paris</P><P>&nbsp;&nbsp;&nbsp; newyork</P><P>&nbsp;&nbsp;&nbsp; denmark</P><P>&nbsp;&nbsp;&nbsp; holland</P><P>&nbsp;&nbsp;&nbsp; Austin</P><P>&nbsp;&nbsp;&nbsp; Jimmy&nbsp;&nbsp;&nbsp; </P><P>]Where not Match(Geography,'Austin','Jimmy');</P></BODY></HTML> Sat, 21 Jun 2014 08:36:36 GMT https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720954#M676980 its_anandrjs 2014-06-21T08:36:36Z Re: need help in using inline properly https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720955#M676981 <HTML><HEAD></HEAD><BODY><P>can i do it using applymap</P></BODY></HTML> Sat, 21 Jun 2014 08:43:48 GMT https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720955#M676981 2014-06-21T08:43:48Z Re: need help in using inline properly https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720956#M676982 <HTML><HEAD></HEAD><BODY><P>mapbook:</P><P>mapping load * inline [</P><P>from,to</P><P>london, austin</P><P>paris, austin</P><P>new york, austin</P><P>denmark, austin</P><P>holland, jimmy</P><P>];&nbsp;&nbsp;&nbsp; </P><P></P><P>geography:</P><P>load geography, <STRONG>ApplyMap</STRONG>('mapbook', geography) as book;</P><P>load * inline [</P><P>geography</P><P>london</P><P>paris</P><P>new york</P><P>denmark</P><P>holland</P><P>];</P></BODY></HTML> Sat, 21 Jun 2014 12:06:51 GMT https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720956#M676982 maxgro 2014-06-21T12:06:51Z Re: need help in using inline properly https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720957#M676983 <HTML><HEAD></HEAD><BODY><P>But you have to hard code the table and do the mapping load for the table Book.</P><P></P><P>Book:</P><P>Mapping LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Geography,Book</P><P>&nbsp;&nbsp;&nbsp; london,Austin</P><P>&nbsp;&nbsp;&nbsp; paris,Austin</P><P>&nbsp;&nbsp;&nbsp; newyork,Austin</P><P>&nbsp;&nbsp;&nbsp; denmark,Austin</P><P>&nbsp;&nbsp;&nbsp; holland,Jimmy<SPAN style="font-size: 10pt; line-height: 1.5em;">];</SPAN></P><P></P><P>Geography:</P><P>LOAD Geography,ApplyMap('Book',Geography) as Book;</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Geography</P><P>&nbsp;&nbsp;&nbsp; london</P><P>&nbsp;&nbsp;&nbsp; paris</P><P>&nbsp;&nbsp;&nbsp; newyork</P><P>&nbsp;&nbsp;&nbsp; denmark</P><P>&nbsp;&nbsp;&nbsp; holland];</P></BODY></HTML> Sat, 21 Jun 2014 13:16:39 GMT https://community.qlik.com/t5/QlikView/need-help-in-using-inline-properly/m-p/720957#M676983 its_anandrjs 2014-06-21T13:16:39Z