Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Data Aggregation problem on creating hierarchy

Hi Friends,

I have an issue in getting the correct data displayed because of the hierarchies I have created. Below is the data:

So I have 3 tables viz Entity, Account and Data table. Entity and Account have hierarchies in them. So I have used hierarchy function as follows

Entity:

Hierarchy (EID, Parent_EID, ELabel)

Load * inline [

EID, Parent_EID, ELabel

0, -1, Null

1, 0, A

2, 1, B

3, 1, C

4, 2, D

5, 2, E

6, 3, F];

Account:

Hierarchy (AID, Parent_AID, ALabel)

Load * inline [

AID, Parent_AID, ALabel

0, -1, Null

1, 0, 100

2, 1, 200

3, 1, 300

4, 2, 400

5, 2, 500

6, 3, 600

];

Data:

Load * inline [

ELabel, ALabel, Amount

A, 100, 10000

B, 200, 5000

C, 300, 5000

D, 400, 3000

E, 500, 2000

F, 600, 5000

];

Here, A = B+C; B = D+E, C = F where D,E,F are leaf nodes containing the data. But in the data table, the amount is aggregated at all the levels. I want to see the Amount as 10000 on clicking A and 100 for entity and Account. But I see 20000 as QlikSense is aggregating the data again when it interprets from the hierarchy.

Please provide a solution to solve this issue.

1 Reply
Not applicable

Re: Data Aggregation problem on creating hierarchy

Hi Aum, I have a similar need. Did you get any solution to your problem?