Hi all,
I am New to qlik.
I want to calculate the count of ID's where planned date is equal to Closed date
Ex
Input table:
ID
| Planned | Closed |
|---|
| 1001 | 1/4/2018 | 2/4/2018 |
| 1002 | 2/4/2018 | 2/4/2018 |
| 1003 | 2/4/2018 | 4/4/2018 |
| 1004 | 4/4/2018 | 4/4/2018 |
Output Looking:
| Date | Planned Count | Closed | Closed Old | Carry to next Date |
|---|
| 1/4/2018 | 1 | 0 | 0 | 1 |
| 2/4/2018 | 2 | 1 | 1 | 1 |
| 4/4/2018 | 1 | 1 | 1 | 0 |
here Closed is where Id's closed in time to the planned date.
Closed Old is Where Id's not closed in Planned date but its closed in next date
Can you pleas suggest the solution for this.
