Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Calendar for table with two dates

I have a feeling I'm missing something obvious here, so I'm hoping one of you can help me out:

I have a table with the following fields:

  • Notice
  • Concern
  • Opened_Date
  • Closed_Date

My end goal is to create a chart with a dimension of days (every day in the calendar, starting from the earliest Opened_Date), and two expressions: 1) The Count of Notices that were opened on the day in question, and 2) The Count of Notices that were closed on the day in question.

I'm not sure how to create a calendar that will connect to the existing table, and let me check if Opened_Date = [Whatever Date Field is Called] and Closed_Date = [Whatever Date Field is Called].


Any thoughts? Thanks in advance!

Tags (1)
1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: Calendar for table with two dates

Hi,

May be this help you Canonical Date

2 Replies
ahaahaaha
Honored Contributor

Re: Calendar for table with two dates

Hi,

May be this help you Canonical Date

Not applicable

Re: Calendar for table with two dates

I think this is exactly what I needed, thank you!

Community Browser