Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
scotthan
Contributor III
Contributor III

Show only certain values in a list box

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.

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.)

Any ideas? Thanks.

1 Solution

Accepted Solutions
whiteline
Master II
Master II

Hi.

This should do the trick:

=aggr(if(LoadDate=vMaxLoadDate,FieldA),  FieldA)

View solution in original post

1 Reply
whiteline
Master II
Master II

Hi.

This should do the trick:

=aggr(if(LoadDate=vMaxLoadDate,FieldA),  FieldA)

View solution in original post