topic All Data filter in QlikView https://community.qlik.com/t5/QlikView/All-Data-filter/m-p/223607#M76106 <HTML><HEAD></HEAD><BODY><P>Hi Daniel,</P><P>By using Joins U wil b get wat u want.</P><P>Warm Regards,</P><P>Sri</P><P></P></BODY></HTML> Wed, 15 Dec 2010 09:21:58 GMT 2010-12-15T09:21:58Z All Data filter https://community.qlik.com/t5/QlikView/All-Data-filter/m-p/223606#M76105 <HTML><HEAD></HEAD><BODY><P>I have 3 tables:</P><P>Building --&lt; Material --- InStock</P><P>--&lt; One-to-many; --- one-to-one</P><P><EM>Building:</EM> BuildingID</P><P><EM>Material:</EM> BuildingID, MaterialID</P><P><EM>InStock:</EM> MaterialID, InStock</P><P></P><P>Selecting InStock='Yes' filters to Buildings that have any number of Materials in stock. How do I show only Buildings where ALL materials needed for that building are in stock?</P><P>Any ideas?</P><P>Daniel</P></BODY></HTML> Wed, 15 Dec 2010 09:18:47 GMT https://community.qlik.com/t5/QlikView/All-Data-filter/m-p/223606#M76105 2010-12-15T09:18:47Z All Data filter https://community.qlik.com/t5/QlikView/All-Data-filter/m-p/223607#M76106 <HTML><HEAD></HEAD><BODY><P>Hi Daniel,</P><P>By using Joins U wil b get wat u want.</P><P>Warm Regards,</P><P>Sri</P><P></P></BODY></HTML> Wed, 15 Dec 2010 09:21:58 GMT https://community.qlik.com/t5/QlikView/All-Data-filter/m-p/223607#M76106 2010-12-15T09:21:58Z