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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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