Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


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.

Not applicable

Hierarchy association problem

I have created a QV test document using excel spreadsheets, one for Data, Target, Calendar and Client Hierarchy. The Client Hierarchy headers are; Client Name, New Client Name, Hierarchy Client, Sector, Reporting Sector and Account Manager.

The particular problem relates where there are multiple companies part of one parent company but where each firm has a different sector type.

Client Name   New Client Name   Hierarchy Name    Sector    Reporting Sector    Account Manager

Client1a!        Client1a                 Client1All              IT          Prof Services          AAA

Client1b~       Client1b                 Client1All              Oil        Prof Services          AAA

QV uses Hierachy Name as the master field. So in the Sector table the individual Client1a amount appears in both IT and Oil. This means the sum total is correct but if you add the individual sector types there sum is greater. Therefore if Client1All is selected from the Hierarchy Client table then in the Sector table the same amount appears in IT and Oil.

Can anyone help me and provide a solution? The script is attached.