How to use SCD in qlikview.

Naps_230 — Tue, 22 Jul 2025 17:59:49 GMT

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

Re: How to use SCD in qlikview.

Vegar — Mon, 27 Mar 2017 05:31:29 GMT

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

Re: How to use SCD in qlikview.

jonathandienst — Mon, 27 Mar 2017 06:30:24 GMT

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)

topic Re: How to use SCD in qlikview. in Archived Groups

How to use SCD in qlikview.

Re: How to use SCD in qlikview.

Re: How to use SCD in qlikview.