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.