Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

mwoolf
Honored Contributor II

Filter two fields with logical OR

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?

1 Solution

Accepted Solutions

Re: Filter two fields with logical OR

You need to create common calendar for them.

Try to use Canonical Calendar.

Canonical Date

3 Replies

Re: Filter two fields with logical OR

You need to create common calendar for them.

Try to use Canonical Calendar.

Canonical Date

Re: Filter two fields with logical OR

Yes, it is:

Canonical Date

hope this helps

regards

Marco

Digvijay_Singh
Honored Contributor III

Re: Filter two fields with logical OR

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

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

Community Browser