topic Re: List Box excluding some data in QlikView https://community.qlik.com/t5/QlikView/List-Box-excluding-some-data/m-p/674899#M1077042 <HTML><HEAD></HEAD><BODY><P>IF(Aggr(SUM(Revenue),Month)&gt;0,Month)</P><P>Use above in List Box Expression</P></BODY></HTML> Tue, 29 Jul 2014 13:30:55 GMT MK_QSL 2014-07-29T13:30:55Z List Box excluding some data https://community.qlik.com/t5/QlikView/List-Box-excluding-some-data/m-p/674898#M1077041 <HTML><HEAD></HEAD><BODY><P><BR />Hello,</P><P></P><P>I have a list box showing the months for 2013. Some of these months have revenues, but July and August have 0 revenue.</P><P></P><P>I want the list box to show all months except July and August.</P><P></P><P>How I can do that ?</P><P></P><P>thks,dani</P></BODY></HTML> Tue, 29 Jul 2014 13:29:31 GMT https://community.qlik.com/t5/QlikView/List-Box-excluding-some-data/m-p/674898#M1077041 danialier 2014-07-29T13:29:31Z Re: List Box excluding some data https://community.qlik.com/t5/QlikView/List-Box-excluding-some-data/m-p/674899#M1077042 <HTML><HEAD></HEAD><BODY><P>IF(Aggr(SUM(Revenue),Month)&gt;0,Month)</P><P>Use above in List Box Expression</P></BODY></HTML> Tue, 29 Jul 2014 13:30:55 GMT https://community.qlik.com/t5/QlikView/List-Box-excluding-some-data/m-p/674899#M1077042 MK_QSL 2014-07-29T13:30:55Z