topic Hierarchy Quesion in QlikView

Hierarchy Quesion

Fri, 12 Feb 2010 10:30:36 GMT

Hello all, hope someone can help with the following:

The scenario that I have consists of a central table of change records, each with a unique reference number.

Each of these changes can impact one or more 'organisations'.

These organisations form part or a organisation structure, which is held in an organsation table e.g.

Company 1 Dept 1 Org 1

Company 1 Dept 1 Org 2

Company 1 Dept 2 Org 3

Company 1 Dept 2 Org 4

Company 2 Dept 3 Org 5

Company 2 Dept 4 Org 6

Company 2 Dept 5 Org 7

Company 2 Dept 5 Org 8

The links to the changes occur at an Organisation level, and are held in a seperate link table, but there is a requirement to report at both Dept level and a Company level.

For instance, "Volume of changes impacting Company 1".... "Volume of changes impacting Dept 4".

We currently have this working in an OLAP Cube, which understands that if a single change impacts 2 or 3 organsiations in the same company, when asked "how many changes impact the company?" the answer is 1 and so on...

I'm trying to build the same in Qlikview, i have the links set up and working, but cannot see how,. or whether its possible to get Qlikview to understand on a numerical basis that the changes are one and the same when reporting at different levels of the organisational structure.

Can someone advise whether this is possible, and if so how i could achieve it?

Thanks again

Hierarchy Quesion

Fri, 12 Feb 2010 12:17:27 GMT

Presumably each change has a 'unique' change number that could be attributed to each hierarchy it changes ? then you could use this number ?

Hierarchy Quesion

Fri, 12 Feb 2010 12:50:48 GMT

Sorry, i'm not making myself clear...

The changes are not to the hiearchy, they are general IT changes (this is a change management system) that impact different organisations.

The hierarchy is there to assist with reporting.

But yes each change has a unique reference number.

For example

Change 1234

Impacts Organisation1, Organisation2 and Organisation3. All of which sit under Company1.

I want to be able to report on the number of changes affecting each organisation, in this case this will be 1. I also want to be able to say how many changes impact Company1, again in this case this will be 1, not 3. At the minute when i click on Company1, i get Change 1234 listed 3 times, once for each org. Which is ok from a display point of view, but from a statistical point of view when i am reporting on the volume of changes impacting Company1 the volume is tripled, saying there are 3 changes impacting Company1, where in actual fact there is only 1.

Any ideas. I'm hoping this is a common difference between traditional OLAP tools and Qlikview, and there is a standard way of dealing with it that i'm missing?