Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi!
Try this in list box expression field.
=if(ArrivalDate >='10/02/2013 12:00:00 AM',ArrivalDate)
Tx
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)
Your expression should work as written. Can you post a reduced qvw with only the timestamp field sso we can take a look?
-Rob
Hi!
Try this in list box expression field.
=if(ArrivalDate >='10/02/2013 12:00:00 AM',ArrivalDate)
Tx
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?