Availed days in qlikview expression

capriconuser — Sat, 16 Nov 2024 03:04:55 GMT

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

Re: Availed days in qlikview expression

capriconuser — Sat, 06 Jul 2019 19:02:45 GMT

any help please

Re: Availed days in qlikview expression

capriconuser — Sun, 07 Jul 2019 05:37:35 GMT

this is the folder .. qlikview file, and output file https://www.dropbox.com/s/v48373io1bv9qqj/file_qlik.rar?dl=0

topic Re: Availed days in qlikview expression in QlikView

Availed days in qlikview expression

Re: Availed days in qlikview expression

Re: Availed days in qlikview expression