topic Re: List box: Select datetime values within a specific time frame in QlikView

List box: Select datetime values within a specific time frame

Anonymous — Tue, 07 May 2013 19:35:24 GMT

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.

Re: List box: Select datetime values within a specific time frame

eddysanchez — Tue, 07 May 2013 20:27:23 GMT

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)

Re: List box: Select datetime values within a specific time frame

rwunderlich — Wed, 08 May 2013 01:41:31 GMT

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

-Rob

Re: List box: Select datetime values within a specific time frame

Wed, 08 May 2013 03:42:42 GMT

Hi!

Try this in list box expression field.

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

Re: List box: Select datetime values within a specific time frame

Anonymous — Wed, 08 May 2013 13:59:16 GMT

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?