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.
