Discussion Board for collaboration on QlikView Scripting.
I'll attach a sample excel file having records below,
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!
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.
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