Discussion Board for collaboration related to Creating Analytics for QlikView.
I am having 2 dates (say) and i want to find
1. The headcounts including exits and new joinees between these two dates.
2. The New joinee headcount between these two dates.
3. The exits between these two dates.
Tried with set analysis Intersaction and exclusion but not getting result . 2 dates are say saturdays, so i will get exits of a week and new joinees.
There are no other dates between these two dates, that means data is for 1/12/2010 , 8/12/2010 , 15/12/2010 order.
can any one give solution in set analysis way.
thanks in advance.
Can you provide a sample for your scenario?