Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 Countjan 18 1feb 18 1mar 18 1apr 18 1may 18 1jun 18 1july 18 1aug 18 1sep 18 1oct 18 1nov 18 1dec 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.