topic select all fields that meet a condition in QlikView https://community.qlik.com/t5/QlikView/select-all-fields-that-meet-a-condition/m-p/442487#M164938 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I have two fields FAMILY and IsCapex</P><P>I want when the user selects a specific sheet to automatically have selection of all FAMILY values where IsCapex = 1</P><P>Please help in the syntax </P></BODY></HTML> Mon, 17 Dec 2012 11:52:17 GMT ali_hijazi 2012-12-17T11:52:17Z select all fields that meet a condition https://community.qlik.com/t5/QlikView/select-all-fields-that-meet-a-condition/m-p/442487#M164938 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I have two fields FAMILY and IsCapex</P><P>I want when the user selects a specific sheet to automatically have selection of all FAMILY values where IsCapex = 1</P><P>Please help in the syntax </P></BODY></HTML> Mon, 17 Dec 2012 11:52:17 GMT https://community.qlik.com/t5/QlikView/select-all-fields-that-meet-a-condition/m-p/442487#M164938 ali_hijazi 2012-12-17T11:52:17Z Re: select all fields that meet a condition https://community.qlik.com/t5/QlikView/select-all-fields-that-meet-a-condition/m-p/442488#M164939 <HTML><HEAD></HEAD><BODY><P>Right click sheet---&gt; go to Triggers---&gt; Add Action---&gt;Select in Field: FAMILY---&gt;</P><P>expression: ='=IsCapex' &amp;'=1'</P></BODY></HTML> Mon, 17 Dec 2012 11:57:48 GMT https://community.qlik.com/t5/QlikView/select-all-fields-that-meet-a-condition/m-p/442488#M164939 2012-12-17T11:57:48Z Re: select all fields that meet a condition https://community.qlik.com/t5/QlikView/select-all-fields-that-meet-a-condition/m-p/442489#M164940 <HTML><HEAD></HEAD><BODY><P>thank you for your prompt reply</P></BODY></HTML> Mon, 17 Dec 2012 12:08:43 GMT https://community.qlik.com/t5/QlikView/select-all-fields-that-meet-a-condition/m-p/442489#M164940 ali_hijazi 2012-12-17T12:08:43Z