Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
thanks a lot!