Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
dpietersz
Creator
Creator
‎2010-01-06 07:36 AM

Fact Table and Slowly Changing Dimension

I have build a Fact table for a CRM system. See the image below. error loading image

I have two problems:

  1. The field "Accountmanager" in the table "Company" needs to be a Slowly Changing Dimension (type 2)
  2. I need to keep the history of every sales record to determine the average sales cycle


I found an example (see this thread) which I think I can use for problem 1. But I don't know how to implement it in my existing datamodel.

Anyone who can help?

1,312 Views
0 Likes
0 Replies