Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Fig1
Contributor III
Contributor III

CHART - USING TWO DIFFERENT DATE FIELDS

I have two date fields.  Date discharged & date completed.  I would like to display the month of discharge (Sept) but include  the number completed (regardless of when discharged). I started with bar and line graph.  Example.  A service will be discharged in July but the date completed (of final paperwork) didn't occur until September.  If I am running the report in September I want to see the number of discharges for Sept and the number of completions in Sept (which would include the july discharge)as a comparison. Make sense?  

1 Reply
Vegar
MVP
MVP

It can be solved by creating a canonical date calendar. Take a look at this blog post by HIC. 

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