1 Reply Latest reply: Dec 14, 2016 7:09 PM by LUCIANO CASTRO RSS

    Data Aggregation problem on creating hierarchy

    Aum Upadhyay

      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.