Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Listbox


Hello everyone,

Little yet annoying problem, I have a listbox with a set of dates, however, I want it to show dates for only the period from 04/11/2013 till 27/11/2013. I tried putting it into sort by expression, but it still returns dates for December too.

Thank you!

Anna

4 Replies
datanibbler
Champion
Champion

Hi Anna,

if you right-click your listbox, in the context-menu you have a subpoint "Advanced search" where you can enter complex search_expressions including IF constructs.

Try entering something along the lines of this:

>>> = [date] >= '04/11/2013' AND [date] <= '27/11/2013' <<<

HTH

Best regards,

DataNibbler

Not applicable
Author

Thank you, but this only provides the search, whereas I'm looking at the listbox displaying only those dates. With expression you have supplied, it searches for the required dates, however, irrelevant dates are still displayed.

Anna

bruno_m_santos
Partner - Creator
Partner - Creator

In List Box, try buil an expression,

if ( [date] >= '04/11/2013' AND [date] <= '27/11/2013' ,  [date], null())

Bruno

sujeetsingh
Master III
Master III

See the sample

In the sample i have just used ad ID in List box but you can see the logic of filltering the value.