Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combine Date Fields

Hello,

I have 3 date fields, Submitted Date, Approval Date, and Terminated Date. I have 3 columns in my table:

Count (Submitted Date)

Count (Approval Date)

Count (Terminated Date)

I would like to know if it is possible to have 1 date field that, I can filter by, that would affect all 3.

For example if I choose 01/01/2016 on my new field it would filter the 3 dates for my table. I provided a screenshot of my table and the Date fields.

The current behavior is that if I change my Approval Date to 01/01/2016 it filters my Total Approved column perfectly but not the others.

Thank you,

Ismael

1 Reply
swuehl
MVP
MVP

You can do this using a

Canonical Date