Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: Combine Date Fields

You can do this using a

Canonical Date