Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Graph with Count Records between 2 dates

Hello,

I'm new to Qlik Sense and i'm still exlporing its capabilities. I've been researching but for what it seems a simple graphic i'm facing no example to overcome it. If anyone can help, it will be appreciated.

I have data records with two variables, Start_Date and End_Date, with date format. I would like to have a bar code graph for which i count the number of records that are within the months of these two variables.

The bar code graph will have in x-axis the Month of the Start_Date variable, whihc is a Dimension.

Thanks in advance for the support.

1 Reply
Anonymous
Not applicable
Author

You may well need to use the IntervalMatch() function in your load script.

Have look at this blog post, IntervalMatch