Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pokermon
New Contributor II

Poor data structure???

Hi everyone,

I'm pulling my hair out with this one. Do I have poorly arranged data, can I really do what I want it to do???

Here's a look at the data structure

data structure.PNG

And here's the viz...

Viz.JPG

The top left scatter is using a drill down dimension of Business Area>Milestones>Outcomes, when I select one of them, I'm hoping to see the scatter plots on the right update with the amount of leads and new work the associated staff have generated, as you can see this doesn't seem to work as planned (the summing of their 'cost to business' is very wrong). Potential Leads and New Work are assigned to the Milestones that they contribute towards.

I've attached the .qvf if any of you good people could spend a few minutes looking at it and see where I'm going wrong please???

Many thanks,

Leo

3 Replies
JustinDallas
Valued Contributor II

Re: Poor data structure???

Can you give us a selection criteria, and what is should be?  For instance, tell us {Business Area = Finance} the Sum(Cost To Business) should = 100.  Generally, when I have an issue like this, I will make a straight table and where I can see all my Sum totals and all the dimensions that are available.

Debug.PNG

pokermon
New Contributor II

Re: Poor data structure???

Hi Justin,

So what should happen is as follows:

When I select finance on the top left scatter, the scatters to the right will update to show me only the people in that area of the business, the x axis will show their individual cost to business (i.e. salary) and the y axis shows me how many potential leads they have produced. I can get this to work when I change the data association as shown below, but then the bottom left tree map doesn't work...

data structure2.JPG

Viz2.JPG

either way I associate the data I get part of it working, but not the other.

Below is an example of what i'm after, but can only obtain this once I've changed the data associations as above (but as mentioned, this then breaks the tree map).

output1.JPG

Any ideas???

Digvijay_Singh
Honored Contributor III

Re: Poor data structure???

Not sure but it could be because you are treating staff ID in different tables as different business names. What if you associate your staff IDs instead of business areas or milestones. What if you join Goals, Financials and potential leads tables and keep staff Id/milestones as the main keys of association.

Community Browser