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>
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.
Take a look at my colleague Tim Little's blog post on the topic.
Vegar Lie Arntsen
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
And your SCD table looks something like:
You can incorporate this using an interval match join:
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)