Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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