Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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:


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!

Tags (1)
Community Browser