Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'll attach a sample excel file having records below,
Employee ID | Employee Name | Gender | Status | Date Hired |
E-2012-0001 | Zac Efron | Male | Single | 1/14/2012 |
E-2012-0002 | Selena Gomez | Female | Single | 1/15/2012 |
E-2012-0003 | Channing Tatum | Male | Single | 2/15/2012 |
E-2012-0004 | Amanda Seigfred | Female | Single | 3/2/2012 |
E-2012-0005 | Beyonce Knowles | Female | Married | 3/3/2012 |
E-2012-0006 | JoJo | Female | Single | 3/5/2012 |
E-2012-0007 | Jesse McCartney | Male | Single | 4/2/2012 |
E-2012-0008 | Mariah Carey | Female | Married | 4/2/2012 |
E-2012-0009 | Brian McKnight | Male | Married | 4/2/2012 |
That is the only table, but how can I know, if one of the employees changes the STATUS from SINGLE to MARRIED?
How can I track changes or apply the SLOWLY CHANGING DIMENSION?
Please help asap. I need this to track as of dates reports.
==================================================================
Say for example,
As of June 6, 2012 Zac Erfron is Single, but as of Aug 1, 2012 he's Married. reports like that!
==================================================================
Best Regards,
Bill
Hi,
I checked your sample excel. There's no status date and no one listed there changes status.
you should included the date they change status.
then you can use intervalmatch() function.
See qlikview help on how to use the said function.
Regards,
Alex
Hi Alexis,
Is there a way to have that history on my own? Coz when we have to compare it to reality, changes happen w/o any record listing.
Anyway, I've got solution for that! Thanks for the help.
post the solution