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