Can I return date related and status related items?

[#1]

I need to see all items that have a "Status" of active (flag in recordset) and anything that the Date filtering can find, at the same time.  Always what active records.  Is there an "OR" option that I might find and use?

Thanks for your time,

Hugh 

[peter_turner]

Hi Hugh,

If your loading the data in the script you could use something like this:

My_Table:

LOAD

field1,

field2,

Status,

Date

FROM Database

WHERE

Status = 'Active'

OR

Date >'02/04/2015'

The exact filters would depend on your data, and particularly how your Date data is formatted in the database.

Also if your using SQL or similar you could perform that filtering at the SQL level so the data that is returned to QlikView is already filtered down.

[anbu1984]

If you need items which need to satisfy both status and date, then you should use AND