Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
fionagrace
New Contributor II

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
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