Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Shahzad_Ahsan
Contributor II

How to manage two dates in single dashboard

Dear Friends

I have an issue with the dates. I have two date fields 'Creation_Date' and 'Cancelled_Date'

I want to filter data by Year/Quarter/Months/Days using ONLY ONE FILTER.

I need two KPIs

1. Number of items created       Expression:  Count (Id)

2. Number of items cancelled    Expression:  Count(Id) where CancelStatus='Cancel'

How is this possible.

Sample data is attached

1 Solution

Accepted Solutions

Re: How to manage two dates in single dashboard

Check here

Canonical Date

2 Replies

Re: How to manage two dates in single dashboard

Check here

Canonical Date

Shahzad_Ahsan
Contributor II

Re: How to manage two dates in single dashboard

Hi Sunny

After lots of effort, I successfully implemented the concept of canonical date.

Thank You

Community Browser