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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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