Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
federerman
New Contributor III

Best Practices Data Modelling- Using the same source data for multiple dimensions

What are the best practices when creating a model that uses the same source data for multiple dimensions?

In particular, let’s say I have an Issue tracking system.  An issue belongs to a particular Project (BI, Data, etc.).  An issue is Reported by an employee.  The issue is then Assigned to an employee.  Hours worked are then tracked to this issue.  The traditional data model looks like this:

ChartModel.png

 

 

 

 

 

 

 

Note that this model requires employee source data be read twice.  Though it is makes charts like this very straightforward:

Chart A.png

Chart B.png

But, what if I want to create a table that shows number of issues assigned/reported to each employee and the hours spend on assigned and reported issues.  Maybe even include some comparison metrics. See example table below:

Chart C.png

Given this data model, there is no way to contract this table.  I was only able to create this chart using a heavily altered data model that makes other forms of analysis a pain.

Can a model be created where that allows all three charts to be created (A, B, C)?

See attached QVFs:

1 Reply
federerman
New Contributor III

Re: Best Practices Data Modelling- Using the same source data for multiple dimensions

Couldn't find a way to edit post.  Looks like the screenshots didn't make it in the right order.

 

For reference, charts A/B/C should be these images:

Chart A.png

Chart B.png

Chart C.png