1 Reply Latest reply: May 2, 2013 9:33 AM by Giovanne Bergstein RSS

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

      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