topic Need to stop filter in table box in QlikView https://community.qlik.com/t5/QlikView/Need-to-stop-filter-in-table-box/m-p/941279#M948371 <HTML><HEAD></HEAD><BODY><P>Hi,&nbsp; I have a scenario in which i need to make a column clickable in tablebox and need to show the detail report in another tab on the basis of a Id. so the problem is when i click on a column then table box filters the records on the basis of that column so I want to stop filtering on that column.</P></BODY></HTML> Wed, 16 Dec 2015 14:38:14 GMT 2015-12-16T14:38:14Z Need to stop filter in table box https://community.qlik.com/t5/QlikView/Need-to-stop-filter-in-table-box/m-p/941279#M948371 <HTML><HEAD></HEAD><BODY><P>Hi,&nbsp; I have a scenario in which i need to make a column clickable in tablebox and need to show the detail report in another tab on the basis of a Id. so the problem is when i click on a column then table box filters the records on the basis of that column so I want to stop filtering on that column.</P></BODY></HTML> Wed, 16 Dec 2015 14:38:14 GMT https://community.qlik.com/t5/QlikView/Need-to-stop-filter-in-table-box/m-p/941279#M948371 2015-12-16T14:38:14Z Re: Need to stop filter in table box https://community.qlik.com/t5/QlikView/Need-to-stop-filter-in-table-box/m-p/941280#M948372 <HTML><HEAD></HEAD><BODY><P>Tricky. You'll need to use the OnAnySelect trigger to clear the selection as soon as it's made. You can use a set analysis expression in the detail report to use the previous (now cleared) selection. For example if you now use sum(Sales) in your report then the set analysis expression would become sum(<STRONG>{$1}</STRONG>Sales). The {$1} creates the set for the previous selection.</P></BODY></HTML> Wed, 16 Dec 2015 17:23:34 GMT https://community.qlik.com/t5/QlikView/Need-to-stop-filter-in-table-box/m-p/941280#M948372 Gysbert_Wassenaar 2015-12-16T17:23:34Z