Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
Fla_Kerwin
New Contributor

Help using Multiple date dimensions in a chart

Hey I am pretty new to Qlik Sense and need some help with a task tracker.  I have a table that has a list of tasks, their start dates and their completed dates and I am trying to develop two charts with this information.  The first is a chart showing how many open tasks I had on at a time over the last year, with each week as a data point.  If there was a task not completed prior to the week or started during that week it should be counted as open for the chart. 

The second chart should show me the ratio of tasks started each week divided by the number of tasks closed that week.  My dimensions are the task name and each date.  I am unsure how to go about combining two date dimensions like this in a single line chart.  Any assistance would be greatly appreciated!

1 Solution

Accepted Solutions
Fla_Kerwin
New Contributor

Re: Help using Multiple date dimensions in a chart

I found a solution to my problem here just in case anyone searchers for my issue again:

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

 

1 Reply
Fla_Kerwin
New Contributor

Re: Help using Multiple date dimensions in a chart

I found a solution to my problem here just in case anyone searchers for my issue again:

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578