0 Replies Latest reply: Mar 15, 2017 7:24 AM by Mats Schlünder RSS

    QlikView Hierarchy Function - using an existing QlikView table as source

    Mats Schlünder

      Hi everyone,

       

      I've used account hierarchies in QlikView to analyze financial data (balance sheets, income statements, etc.).

       

      So far, I had to transform data in excel to generate the data structure QlikView requires to recreate.

      the account hierarchy (see:  Hierarchy in QlikView ).

       

      More specifically, I generated the hierarchy keys and parent keys with excel functions and vba programming 
      which is very time-consuming.

       

      I am now trying to reduce the amount of time I have to spend to update hierarchies within the application to a minimum.

       

      I would like to do the majority of the required transformation in the QlikView script.

       

      I've managed to create a structure which is quite similar to the required one using the following code:

       

      Capture1.PNG

      This creates such a table:

      Capture2.PNG

      I now have to tell QlikView to use a combination of the column letter and row number from this table

      as the hierarchy key (e.g. for account number 1110000: hierarchy key: D4, parent key: C3) so that

      I can use the hierarchy in a list box.

       

      Does anyone how to achieve this?

       

      I will attach the source file and the sample application.

       

      Please let me know if you have any further questions.

       

      Thank you in advance.

       

      Best regards,

       

      Mats