Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

Availed days in qlikview expression

I am trying to get days from given data like this this is data

data.PNG

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...

data_qlik.PNG

any help

Labels (1)
2 Replies
capriconuser
Creator
Creator
Author

any help please

capriconuser
Creator
Creator
Author

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