List box: Select datetime values within a specific time frame

[Anonymous]

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.

[eddysanchez]

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]

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

-Rob

[#4 · Accepted solution]

Hi!

Try this in list box expression field.

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

Tx

[Anonymous]

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?