topic Show only certain values in a list box in QlikView https://community.qlik.com/t5/QlikView/Show-only-certain-values-in-a-list-box/m-p/655045#M239289 <HTML><HEAD></HEAD><BODY><P>Hi, I am trying to show only values in FieldA with the most recent Load Date. I can use an expression like =if(LoadDate=vMaxLoadDate,FieldA) but that's no good because when you make a selection, LoadDate pops up in your current selections box.</P><P></P><P>I was using field triggers and a hidden field to try to solve this, but the client noticed that the back button doesn't work properly when I created that. (You had to hit the back button multiple times to go back.)</P><P></P><P>Any ideas? Thanks.</P></BODY></HTML> Wed, 25 Jun 2014 20:08:23 GMT scotthan 2014-06-25T20:08:23Z Show only certain values in a list box https://community.qlik.com/t5/QlikView/Show-only-certain-values-in-a-list-box/m-p/655045#M239289 <HTML><HEAD></HEAD><BODY><P>Hi, I am trying to show only values in FieldA with the most recent Load Date. I can use an expression like =if(LoadDate=vMaxLoadDate,FieldA) but that's no good because when you make a selection, LoadDate pops up in your current selections box.</P><P></P><P>I was using field triggers and a hidden field to try to solve this, but the client noticed that the back button doesn't work properly when I created that. (You had to hit the back button multiple times to go back.)</P><P></P><P>Any ideas? Thanks.</P></BODY></HTML> Wed, 25 Jun 2014 20:08:23 GMT https://community.qlik.com/t5/QlikView/Show-only-certain-values-in-a-list-box/m-p/655045#M239289 scotthan 2014-06-25T20:08:23Z Re: Show only certain values in a list box https://community.qlik.com/t5/QlikView/Show-only-certain-values-in-a-list-box/m-p/655046#M239290 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>This should do the trick:</P><P>=aggr(if(LoadDate=vMaxLoadDate,FieldA),&nbsp; FieldA)</P></BODY></HTML> Wed, 25 Jun 2014 20:19:06 GMT https://community.qlik.com/t5/QlikView/Show-only-certain-values-in-a-list-box/m-p/655046#M239290 whiteline 2014-06-25T20:19:06Z