Discussion board where members can get started with Qlik Sense.
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
Go to Solution.
After lots of effort, I successfully implemented the concept of canonical date.