Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

shayraber
Contributor

Qlik SAP and Hierarchy

working with SAP R/3

want to create an hierarchy (finance related) in order to create a structured balance sheet based on the tables:

1. SETNODE

2. SETLEAF

SETNODE holds 2 relevant fields:

SETNAME = a parent node's name

SUBSETNAME = a node's name

the rules is:

if a SUBSETNAME value has no record where it is a SETNAME - then, it's a leaf, else - it's a node and it has SUBSETNAME values where it is a SETNAME

SETLEAF holds 3 relevant fields:

SETNAME = the leaf's name

VALFROM and VALTO = boundries for the range of data for that leaf

using the hierarchy(NodeID, ParentNodeID,...) function didn't seem to work, or maybe i didn't use it properly?


Please assist

Shay

1 Solution

Accepted Solutions

Re: Qlik SAP and Hierarchy

  • Search the community (section Documents) for the Qlik Start Templates and download an archive that contains the General Ledger template.
  • Extract the files from the archive.
  • Open the FI-GL QVD Generator in QV Desktop.
  • Launch the Script Editor (Ctrl-E)
  • Navigate to a script tab called "Account Hierarchies (OLD)".
  • Enjoy.

Best,

Peter

View solution in original post

3 Replies

Re: Qlik SAP and Hierarchy

  • Search the community (section Documents) for the Qlik Start Templates and download an archive that contains the General Ledger template.
  • Extract the files from the archive.
  • Open the FI-GL QVD Generator in QV Desktop.
  • Launch the Script Editor (Ctrl-E)
  • Navigate to a script tab called "Account Hierarchies (OLD)".
  • Enjoy.

Best,

Peter

View solution in original post

shayraber
Contributor

Re: Qlik SAP and Hierarchy

Thanks a lot!

the perfect answer to my issue

very helpful!

Partner
Partner

Re: Qlik SAP and Hierarchy

Thanks a lot!