topic Filter two fields with logical OR in QlikView

Filter two fields with logical OR

m_woolf — Mon, 26 Jan 2026 18:19:17 GMT

I have a Plan Date field and an Actual Date field.

The user wants to select a year (2018) and see all records where the Plan Date OR the Actual Date has that year.

Is this even possible?

MK_QSL — Tue, 27 Mar 2018 19:28:41 GMT

You need to create common calendar for them.

Try to use Canonical Calendar.

MarcoWedel — Tue, 27 Mar 2018 19:29:23 GMT

Yes, it is:

hope this helps

regards

Marco

Digvijay_Singh — Tue, 27 Mar 2018 19:30:32 GMT

May be set expression can be used like this in chart measures -

{<ActualDate={"=Year(ActualDate)=Max(Year)"}>+<PlannedDate={"=Year(PlannedDate)=Max(Year)"}>}