6 Replies Latest reply: Dec 1, 2016 9:34 AM by Court van de Lisdonk RSS

    Hierarchy for my Listbox ProductGroups

    Court van de Lisdonk

      Hello,

       

      I want to create a Listbox with a Treeview for ProductGroups.

       

      This QVD will be loaded for the Listbox

      [HierProductGroup]:

      LOAD

      Company,

           DataLevel,

            LoadingDate,

            LevelCount,

            RootCode,

            RootName,

            LeafCode,

            LeafName,   

            Level01Code,   

           Level01Name,   

            Level02Code,

            Level02Name,

            Level03Code,

            Level03Name,

            Level04Code,

            Level04Name,

            CodePath,

            CodeName

      FROM [C:\Qlikview\Datasources\qvd\DimHier_PrimDimProductGroup.qvd] (qvd);

       

      The fields LeafCode, Level01Code, Level02Code, Level03Code & Level04Code should be the Levels in my Listbox. Where LeafCode is the Parent and the Level xx Code are the Children. In every example I saw,  there are always Parent-ID, ChildID's, Path, '-' and HierarchyLevel. I don't have them in my QVD.

       

      When I use the QLIKVIEW LOADStatement  I can take the Option Hierarchy : HIERARCHY(Level01Code, LeafCode, Level01Name, LeafName, Path, '-', HierarchyLevel )

       

      When I run the script I have no Problems, only there is no Hierarchy so I can not use the TreeView option

       

      I hope someone can help me

       

      Thanks in regards

       

      Court