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: 
ishanbansal1204
Contributor III
Contributor III

Query to count the same records for every month between start date and end date

I have a dataset which has ID, start date, department, end date. I want to get the query where if the

id is 1 , start date is jan 2018 , dept : abc, end date is jan 2019

the output should be

Month Count
jan 18 1
feb 18 1
mar 18 1
apr 18 1
may 18 1
jun 18 1
july 18 1
aug 18 1
sep 18 1
oct 18 1
nov 18 1
dec 18 1

I have taken only 1 records but we have to consider multiple records.

count starts from 1 from the start date and goes on till end date -1

I hope i am clear in my explanation.

I am using Qlik Sense.

I had tried with different approach with copy pasting records for multiple times but it is time consuming and not the exact solution.

0 Replies