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: 
Anonymous
Not applicable

List box: Select datetime values within a specific time frame

I have a dashboard that includes a list box that contains the timestamp field for the records being displayed. I would like to be able to use an Advanced Search to select only those records that are more recent that a certain datetime. I thought I could do this by simply entering an expression like '> 4/30/2013 10:07:15 AM' but QlikView doesn't seem to like this. I click Go and the Advanced Search dialog box remains on screen. What should the syntax be for this selection?

Thank you.

1 Solution

Accepted Solutions
Not applicable
Author

Hi!

Try this in list box expression field.

=if(ArrivalDate >='10/02/2013 12:00:00 AM',ArrivalDate)

Tx

View solution in original post

4 Replies
eddysanchez
Partner - Creator
Partner - Creator

Try creating a listbox with the expression:

=If(Date<$(=Only(Date)),null(),Date)

And sort Numeric-ascending. Need select one Date

Or for variable:

=If(Date<$(vDateReference),null(),Date)

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Your expression should work as written. Can you post a reduced qvw with only the timestamp field sso we can take a look?

-Rob

Not applicable
Author

Hi!

Try this in list box expression field.

=if(ArrivalDate >='10/02/2013 12:00:00 AM',ArrivalDate)

Tx

Anonymous
Not applicable
Author

shihani_ss, that worked. Thank you. I was able to simplify it further to

=ArrivalDate >='10/02/2013 12:00:00 AM'.

What's the advantage to doing it as an IF statement?