Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use intervalmatch to determine the interval in months and group data to count the days to daily
Use intervalmatch to determine the interval in months and group data to count the days to daily