Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How can I implement SCD w/ only 1 table as source?

Hi,

I'll attach a sample excel file having records below,

Employee IDEmployee NameGenderStatusDate Hired
E-2012-0001Zac EfronMaleSingle1/14/2012
E-2012-0002Selena GomezFemaleSingle1/15/2012
E-2012-0003Channing TatumMaleSingle2/15/2012
E-2012-0004Amanda SeigfredFemaleSingle3/2/2012
E-2012-0005Beyonce KnowlesFemaleMarried3/3/2012
E-2012-0006JoJoFemaleSingle3/5/2012
E-2012-0007Jesse McCartneyMaleSingle4/2/2012
E-2012-0008Mariah CareyFemaleMarried4/2/2012
E-2012-0009Brian McKnightMaleMarried4/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

3 Replies
Not applicable

Re: How can I implement SCD w/ only 1 table as source?

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

Not applicable

Re: How can I implement SCD w/ only 1 table as source?

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.

Not applicable

Re: How can I implement SCD w/ only 1 table as source?

post the solution