Hello Everyone,
I am new to Qlik Sense and I need help in creating the single date filter for the different date dimension,
I currently I have the data model as below
Tasks Table
| taskid | taskname |
| 1 | First Task |
| 2 | Second Task |
Tasks Dates
| taskid | task_created | task_paused | task_stopped |
| 1 | 2019-01-01 | 2019-04-15 | 2019-06-10 |
| 2 | 2019-03-01 | 2019-04-10 | 2019-06-16 |
| 3 | 2019-06-01 | 2019-06-15 | 2019-06-28 |
Now I wanted to create the single date filter which should be able to do the job for all the three dimensions i.e. task_created,task_paused,task_stopped.
I have gone through below posts but I do not succeed to achieve this, Can you please guide me?
- https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578
- https://community.qlik.com/t5/New-to-QlikView/Creating-a-Data-Model-with-Canonical-Date/m-p/1224631
- https://community.qlik.com/t5/New-to-QlikView/Canonical-Date/m-p/5773
