topic Re: Enable corresponding details in reports in QlikView https://community.qlik.com/t5/QlikView/Enable-corresponding-details-in-reports/m-p/773678#M1045090 <HTML><HEAD></HEAD><BODY><P>left join AI to AVI with ID as key</P></BODY></HTML> Thu, 04 Dec 2014 08:29:13 GMT 2014-12-04T08:29:13Z Enable corresponding details in reports https://community.qlik.com/t5/QlikView/Enable-corresponding-details-in-reports/m-p/773677#M1045089 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have two table (for ex, AI, AVI), both table having common column is ID this details display into table box, when user click <STRONG>Name</STRONG> filed in AI table, now client want&nbsp; expecting&nbsp; whatever associate record display&nbsp; into <STRONG>AVI table</STRONG> please hel me , what way can I proceed, i am tried Trigger but no propper output?</P><P> AI: </P><TABLE border="1" cellpadding="0" cellspacing="0" height="467" style="padding: 0px 5.4pt; border: currentColor; width: 183px; height: 378px;"><TBODY><TR><TD style="padding: 0px 5.4pt; border: 1pt solid windowtext;" valign="top" width="49"><P>ID</P><BR />&nbsp; </TD><TD style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="54"><P>Name</P><BR />&nbsp; </TD><TD style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="96"><P>Desccription</P><BR />&nbsp; </TD></TR><TR><TD style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentColor windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="49"><P><STRONG style="color: #00b050;">101</STRONG></P><BR />&nbsp; </TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="54"><P><STRONG style="color: #c00000;">ABC</STRONG></P><BR />&nbsp; </TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="96"><P>Checking data&nbsp; quality</P><BR />&nbsp; </TD></TR><TR><TD style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentColor windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="49"><P> 102</P><BR />&nbsp; </TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="54">BCD<BR />&nbsp; </TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="96">Maintain data quality<BR />&nbsp; </TD></TR><TR><TD style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentColor windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="49">103<BR />&nbsp; </TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="54">CDE<BR />&nbsp; </TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="96">Check Data quality<BR />&nbsp; </TD></TR></TBODY></TABLE><P></P><P>AVI:</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" height="407" style="padding: 0px 5.4pt; border: currentColor; width: 261px; height: 370px;"><TBODY><TR><TD style="padding: 0px 5.4pt; border: 1pt solid windowtext;" valign="top" width="49"><P>ID</P><BR />&nbsp; </TD><TD style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="72"><P><SPAN style="font-size: 9pt;">Version No</SPAN></P><BR />&nbsp; </TD><TD style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="84"><P>Status</P><BR />&nbsp; </TD></TR><TR><TD style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentColor windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="49"><P><SPAN style="color: #00b050;">101</SPAN></P></TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="72"><P>1</P><BR />&nbsp; </TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="84"><P>Assign</P><BR />&nbsp; </TD></TR><TR><TD style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentColor windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="49"><P>101</P> </TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="72"><P>2</P><BR />&nbsp; </TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="84"><P>WIP </P></TD></TR><TR><TD style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentColor windowtext windowtext; padding: 0px 5.4pt;" valign="top" width="49"><P>101</P><BR />&nbsp; </TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="72"><P>3</P><P><BR /> </P></TD><TD style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentColor windowtext windowtext currentColor; padding: 0px 5.4pt;" valign="top" width="84"><P>Completed</P></TD></TR></TBODY></TABLE><P></P><P></P><P>Regards,</P><P>Senthil.K</P></BODY></HTML> Thu, 04 Dec 2014 07:51:23 GMT https://community.qlik.com/t5/QlikView/Enable-corresponding-details-in-reports/m-p/773677#M1045089 2014-12-04T07:51:23Z Re: Enable corresponding details in reports https://community.qlik.com/t5/QlikView/Enable-corresponding-details-in-reports/m-p/773678#M1045090 <HTML><HEAD></HEAD><BODY><P>left join AI to AVI with ID as key</P></BODY></HTML> Thu, 04 Dec 2014 08:29:13 GMT https://community.qlik.com/t5/QlikView/Enable-corresponding-details-in-reports/m-p/773678#M1045090 2014-12-04T08:29:13Z