topic Expression in listbox used as volume filter in QlikView https://community.qlik.com/t5/QlikView/Expression-in-listbox-used-as-volume-filter/m-p/196234#M56402 <HTML><HEAD></HEAD><BODY><P>I thougt I would test if it is possible to use an expression in a list box, to let the user click in one place to filter by volume. In this case sales amount by salesman, at fixed sales amount ranges.</P><P>This way I can avoid using varables in other objects to achieve the same thing. It does work somehow, but behaves a little strange. See enclosed app, listbox "Sales by salesman".</P><P>1) If I select "Less than 50000" the selection above is not greyed. It disappears!<BR />2) If I select "Less than 50000" it shows only one salesman, "Elvis Presley", which is correct.<BR />But, if I select year 2009, it still show only one salesman, "Elvis Presley". Because I have limited the data to only 2009 more salesmen should be visible.<BR />Unselect "Elvis Presley", then select "Less than 50000" again and you will see.</P><P>Any idea if this is possible to solve this way at all?<BR />I already know this is possible to solve with variables or macros.</P><P>Lars</P></BODY></HTML> Wed, 23 Sep 2009 19:18:45 GMT larsc 2009-09-23T19:18:45Z Expression in listbox used as volume filter https://community.qlik.com/t5/QlikView/Expression-in-listbox-used-as-volume-filter/m-p/196234#M56402 <HTML><HEAD></HEAD><BODY><P>I thougt I would test if it is possible to use an expression in a list box, to let the user click in one place to filter by volume. In this case sales amount by salesman, at fixed sales amount ranges.</P><P>This way I can avoid using varables in other objects to achieve the same thing. It does work somehow, but behaves a little strange. See enclosed app, listbox "Sales by salesman".</P><P>1) If I select "Less than 50000" the selection above is not greyed. It disappears!<BR />2) If I select "Less than 50000" it shows only one salesman, "Elvis Presley", which is correct.<BR />But, if I select year 2009, it still show only one salesman, "Elvis Presley". Because I have limited the data to only 2009 more salesmen should be visible.<BR />Unselect "Elvis Presley", then select "Less than 50000" again and you will see.</P><P>Any idea if this is possible to solve this way at all?<BR />I already know this is possible to solve with variables or macros.</P><P>Lars</P></BODY></HTML> Wed, 23 Sep 2009 19:18:45 GMT https://community.qlik.com/t5/QlikView/Expression-in-listbox-used-as-volume-filter/m-p/196234#M56402 larsc 2009-09-23T19:18:45Z