Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
New Contributor III

Qlik Sense - Single date filter for different dates using canonical dates

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

taskidtaskname
1First Task
2Second Task

 

Tasks Dates

taskidtask_createdtask_pausedtask_stopped
12019-01-012019-04-152019-06-10
22019-03-012019-04-102019-06-16
32019-06-012019-06-152019-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?

  1. https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578
  2. https://community.qlik.com/t5/New-to-QlikView/Creating-a-Data-Model-with-Canonical-Date/m-p/1224631
  3. https://community.qlik.com/t5/New-to-QlikView/Canonical-Date/m-p/5773
Tags (1)
Labels (2)