topic Fields specific records in QlikView https://community.qlik.com/t5/QlikView/Fields-specific-records/m-p/294558#M109283 <HTML><HEAD></HEAD><BODY><P> Created a second customer name in script for open orders and that did the trick.</P></BODY></HTML> Tue, 27 Sep 2011 18:37:03 GMT 2011-09-27T18:37:03Z Fields specific records https://community.qlik.com/t5/QlikView/Fields-specific-records/m-p/294557#M109282 <HTML><HEAD></HEAD><BODY><P>I have a fact table what includes sales and open orders. In a list box if I have the field "Customer Name" I get all customers with sales and open orders.&nbsp; I want the list box to only show customers with open orders. So I want something like:</P><P>CUST_NAME {$ &lt; SO_TYPE = {"ZLOC","ZTHR"}&gt;}) </P><P>but I can't seem to get the right syntax.</P><P>Help.</P><P>Thanks,</P><P>Stephen</P></BODY></HTML> Tue, 27 Sep 2011 17:32:50 GMT https://community.qlik.com/t5/QlikView/Fields-specific-records/m-p/294557#M109282 2011-09-27T17:32:50Z Fields specific records https://community.qlik.com/t5/QlikView/Fields-specific-records/m-p/294558#M109283 <HTML><HEAD></HEAD><BODY><P> Created a second customer name in script for open orders and that did the trick.</P></BODY></HTML> Tue, 27 Sep 2011 18:37:03 GMT https://community.qlik.com/t5/QlikView/Fields-specific-records/m-p/294558#M109283 2011-09-27T18:37:03Z