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?
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?
