through the entry and exit date of the month how many days were used

[giovanneb]

I have a table of guests, data input and output data, it happens that a guest can get in one month and go in another month, and would have the result of daily how many months were spent in or

example

data input  -  output data

25/12/2011  05/01/2012 = 6 days in the month 12/2011 and 5 days in the month 01/2012

15/01/2012  30/01/2012 = 5 days in the month 01/2012

How can I create this rule in QlikView?

thank you

[giovanneb · Accepted solution]

Use intervalmatch to determine the interval in months and group data to count the days to daily