Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Can I return date related and status related items?

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 

2 Replies
peter_turner
Valued Contributor

Re: Can I return date related and status related items?

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
Honored Contributor III

Re: Can I return date related and status related items?

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

Community Browser