Data Model Creation for the Complex data

Anonymous — Wed, 24 Oct 2018 21:43:13 GMT

Hi All,

I have the different tables table with some common fields and wants to create model to analyse the data.

Table Structures are as given below:

And the related sample created data attached in Excel file with Sheet names as Tabeles, Can you please help me to create data-model with this, please put data-model QVW to get clear understanding.

TrainingItems-TABLE	ActionItems-TABLE	Percentage-TABLE	TrainingHours-TABLE	EnterpriseReport-TABLE	EmployeeTable-TABLE
PlanCreatedDate	PlanCreatedDate	PlanCreatedDate	TransCompleatedDate	EmpID	Company
EmpID	EmpID	EmpID	EmpID	Type	Division
Name	Name	Name	Name	Title	SubDivision
DivisionParent	DivisionParent	PlanProgress	DivisionParent	TrainingProvider	Section
Division	Division	PlanStatus	Division	Score	ID
PlanTitle	PlanTitle	UserManagerName	Status	FullName
PlanTrainItem	PlanActionStep	TrainingProvider	RegisteredDate	DoB
PlanTrainItem_Status	PlanActionStep_Progress	TrainingType	Session_Date	Date of Join
TrainingTitle	Grade
Training_ID	RoleNo
TranscriptStatus	RolneBand
UserStatus	PositionTitle
TrainingHours	Supervisor

Attached source has data aswell.

Thanks,

Ravi

Re: Data Model Creation for the Complex data

Michiel_QV_Fan — Fri, 14 Dec 2018 09:06:16 GMT

https://en.wikipedia.org/wiki/Data_modeling

topic Data Model Creation for the Complex data in QlikView

Data Model Creation for the Complex data

Re: Data Model Creation for the Complex data