Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

shayraber
Contributor

Re: Qlik SAP and Hierarchy

Thanks a lot!

the perfect answer to my issue

very helpful!

valeriaa
New Contributor III

Re: Qlik SAP and Hierarchy

Thanks a lot!

Community Browser