Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Data Structure - Actual vs Target - Multiple Date - Master Canonical Calendar?

 

I am relatively new to Qlikview and have only done a POC that went well and the feedback was to create another report utilizing targets.  To achieve this I needed to bring in 3 source files, Employee Targets, Area Targets, and Actuals.  Employee/Area Targets are structured by a Type field with 3 possibilities Lead, Registration, & Funded and the Actuals are registered by population of the fields Lead_Date, Registration_Date, and Close_Date.  I am trying to achieve a working model to begin developments, but think I need a canonical calendar from what I’ve seen. I did not know if anyone had any insights on the subject.  I believe I need everything to connect to this canonical calendar as the center table, but not sure if that is accurate.  Any guidance would be greatly appreciated. 

 

Below is my current structure.

  Capture.PNG

   

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Data Structure - Actual vs Target - Multiple Date - Master Canonical Calendar?

4 Replies
Highlighted
Creator III
Creator III

Re: Data Structure - Actual vs Target - Multiple Date - Master Canonical Calendar?

Highlighted
Creator III
Creator III

Re: Data Structure - Actual vs Target - Multiple Date - Master Canonical Calendar?

please follow the blog would help

Highlighted
Contributor III
Contributor III

Re: Data Structure - Actual vs Target - Multiple Date - Master Canonical Calendar?

Thank you, that did the trick....  Now just looking to join the data bridge to the targets and created new discussion.

Actual vs Targets - Insert Actual Key into Data Bridge

Highlighted
Creator III
Creator III

Re: Data Structure - Actual vs Target - Multiple Date - Master Canonical Calendar?

please mark it as correct to close this discussion and if you find it useful go to actions and select helpful