Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: CHART - USING TWO DIFFERENT DATE FIELDS

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes