Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to get days from given data like this this is data
in this data suppose ID B start date is 4/10/2019 and end date is 10/25/2019 here there is 7 months April to October month so for first month start date is 4/10/2019 and calendar end date is 4/30/2019 so we this means he only avail 10 days from this month and remaining days is 21.. same for here end date is 10/25/2019 so if we look calendar end date 10/31/2019 we only avail 6 days so in data i want to get above data which is mentioned in image .. where as i am trying this formula in qlikview
=sum(If(MonthName(CalendarMonthEnd) = MonthName([End Date]),([End Date]-CalendarMonthStart+1), (RangeMin([End Date],CalendarMonthEnd)-RangeMax([Start Date],CalendarMonthStart))))
and through this formula i get this data which is remaining days where i want to get days which is availed...
any help
any help please
this is the folder .. qlikview file, and output file https://www.dropbox.com/s/v48373io1bv9qqj/file_qlik.rar?dl=0