topic disconnect field in a table in QlikView https://community.qlik.com/t5/QlikView/disconnect-field-in-a-table/m-p/189258#M52207 <HTML><HEAD></HEAD><BODY><P>Hello, I tried searching the forum but have not found anything.<BR /><BR />Basically I have two tables with some fields in common and some not.<BR />One of these fields is common in the field 'Data'. I would like to filter by selecting the 'Date' only the first table to be filtered, while the second displays all data as if the filter was not applied.<BR /><BR />Thanks!</P></BODY></HTML> Thu, 27 Jan 2011 16:46:42 GMT 2011-01-27T16:46:42Z disconnect field in a table https://community.qlik.com/t5/QlikView/disconnect-field-in-a-table/m-p/189258#M52207 <HTML><HEAD></HEAD><BODY><P>Hello, I tried searching the forum but have not found anything.<BR /><BR />Basically I have two tables with some fields in common and some not.<BR />One of these fields is common in the field 'Data'. I would like to filter by selecting the 'Date' only the first table to be filtered, while the second displays all data as if the filter was not applied.<BR /><BR />Thanks!</P></BODY></HTML> Thu, 27 Jan 2011 16:46:42 GMT https://community.qlik.com/t5/QlikView/disconnect-field-in-a-table/m-p/189258#M52207 2011-01-27T16:46:42Z disconnect field in a table https://community.qlik.com/t5/QlikView/disconnect-field-in-a-table/m-p/189259#M52208 <HTML><HEAD></HEAD><BODY><P>Have a look at 'Set Analysis' in the Help file.</P><P>It's a bit complex but if you work through the examples it's easy enough.</P><P>Should be something like =sum({1} Value) in the second table to ignore selections in the other.</P><P>Hope that helps,</P><P>Matt - Viauls Analytics Ltd</P></BODY></HTML> Thu, 27 Jan 2011 16:49:43 GMT https://community.qlik.com/t5/QlikView/disconnect-field-in-a-table/m-p/189259#M52208 matt_crowther 2011-01-27T16:49:43Z