topic Shrinking list boxes to only associated data in QlikView https://community.qlik.com/t5/QlikView/Shrinking-list-boxes-to-only-associated-data/m-p/496345#M1147361 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>Please can somebody advise what settings are required to shrink a list box to contain only those records relevent to the data displayed on a graph? The list displayed needs to be dynamic based on the selection (e.g. list only those projects associated with a particular Business Unit).</P><P></P><P>Thanks</P></BODY></HTML> Thu, 18 Jul 2013 14:25:53 GMT 2013-07-18T14:25:53Z Shrinking list boxes to only associated data https://community.qlik.com/t5/QlikView/Shrinking-list-boxes-to-only-associated-data/m-p/496345#M1147361 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>Please can somebody advise what settings are required to shrink a list box to contain only those records relevent to the data displayed on a graph? The list displayed needs to be dynamic based on the selection (e.g. list only those projects associated with a particular Business Unit).</P><P></P><P>Thanks</P></BODY></HTML> Thu, 18 Jul 2013 14:25:53 GMT https://community.qlik.com/t5/QlikView/Shrinking-list-boxes-to-only-associated-data/m-p/496345#M1147361 2013-07-18T14:25:53Z Re: Shrinking list boxes to only associated data https://community.qlik.com/t5/QlikView/Shrinking-list-boxes-to-only-associated-data/m-p/496346#M1147362 <HTML><HEAD></HEAD><BODY><P>Not sure what you want. You can try using expressions instead of fields in the listboxes, i.e. aggr(MyField,MyField) instead of the field MyField.</P></BODY></HTML> Thu, 18 Jul 2013 14:40:58 GMT https://community.qlik.com/t5/QlikView/Shrinking-list-boxes-to-only-associated-data/m-p/496346#M1147362 Gysbert_Wassenaar 2013-07-18T14:40:58Z