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:



      This creates such a table:


      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,