Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fpedrosa
New Contributor II

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

Re: Graph with Count Records between 2 dates

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

Have look at this blog post, IntervalMatch