Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count open notices by day

I posted a question last week and got an answer right away, so thank you for that! I have kind of a follow-up question:

Here is my original question post: Calendar for table with two dates

Following that post, I now have 3 tables:

tables.PNG

The next thing I need to do is create a chart with a dimension of each day in the calendar (starting from the earliest OPENED_DATE), and an expression that counts the number of notices that are open on the day in question (i.e. OPENED_DATE <= [Whatever Date Field is Called] and CLOSED_DATE > [Whatever Date Field is Called]). Is there a way to do that? Thanks in advance!

0 Replies