Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

grenwick
New Contributor III

Problem with linked tables for different dates and joins

Hi,

I have four main tables:  This is a "Problem Type -> Case Raised Against Problem Type -> Views on Case" Application.

Table1: A table of problem types and the count of problems per day based on that problem

Table 2:A table of cases raised on that problem

Table 3:A table of views on those cases

Table 4:A master Calendar.

It seems like i have everything in those tables to make it work nicely.

I have included an example.

I would like to have a graph where I could simply see, on a given month (choosen by the master calendar)

The views related to the selected problem or case

The number of cases resolved by day on a selected problem or case

The count of problems raised by day on that selected problem or cases that where associated to the problems which is set by table 2.

The community has been a great help to get me where I am but I think I'm getting something wrong in my relationship building.

1 Solution

Accepted Solutions
grenwick
New Contributor III

Re: Problem with linked tables for different dates and associations with dimensions

This may be the solution. I just added the shared fields in the data link key table. All seems to work now.

2 Replies
grenwick
New Contributor III

Re: Problem with linked tables for different dates and associations with dimensions

Another Update - Very close to what I need but not quite. I may need another linked table but not sure how.

When I select cases that are "software" related (Bug Found and Virus Found), my "problem type" sum should just be the sum of problems related to "software".

When I select two cases related to "software", the sum of problems doubles - how do I stop this?

Any help would be much appreciated.

grenwick
New Contributor III

Re: Problem with linked tables for different dates and associations with dimensions

This may be the solution. I just added the shared fields in the data link key table. All seems to work now.

Community Browser