Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
scotthan
Partner - Contributor III
Partner - 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)