Qlik Community

Qlik Deployment Framework

This group has been created to host, centralize and collect everything related to the Qlik Deployment Framework (QDF). QDF provides a set of best practices, libraries and utilities that facilitate the recommended setup and management of QlikView and Qlik Sense environments. Please note that an understanding of the Qlik platform is recommended before joining this group. <a href="https://github.com/QlikDeploymentFramework/Qlik-Deployment-Framework/releases" rel="nofollow noopener noreferrer noopener noreferrer"> Download QDF 1.7.3 here!</a>

Highlighted
jash
New Contributor

How to use SCD in qlikview.

Hi ALL,

I have some question.

1.Please let me explain, how to use SCD in Qlikview.

2.How to konw what license provide to user in QMC.

Regards

Jasobanta

Tags (1)
2 Replies
Vegar
Valued Contributor

Re: How to use SCD in qlikview.

Hi Jasobanta,

Take a look at my colleague Tim Little's blog post on the topic.

http://bi-effekten.se/2015/05/19/managing-scd1-logic-in-qlikview/

Cheers,

Vegar Lie Arntsen 

Please ekskuse my Norglish and Swenglish typos.
MVP
MVP

Re: How to use SCD in qlikview.

I assume you mean a type 2 slowly changing dimension (see here Slowly changing dimension - Wikipedia‌ and http://www.kimballgroup.com/2008/08/slowly-changing-dimensions/)

This is fairly straightforward in Qlikview using an extended interval match - this is an interval match with one or more key values in addition to the from and to dates.Assuming your fact load includes a date field, like this

Fact:

LOAD

    TransID,

    TransDate,

    ...

And your SCD table looks something like:

Dimension:

LOAD

    From,

    To,

    Key,

    Attribute1,

    Attribute2,

    Attribute3

     ....

You can incorporate this using an interval match join:

IntervalMatch(TransDate, Key)

Left Join(Fact)

LOAD From, To, Key Resident Dimension;

This will add Key, From and To to your Fact table (null if the key and/or dates do not match)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein