Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mvgadagi
Contributor III
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
Labels (1)
0 Replies