3 Replies Latest reply: Jan 2, 2013 7:01 AM by vivekkorani RSS

    Folder Navigation in QLikview

      Hello,

       

      I am migrating some reports from SAP BO (Business Objects) to Qlikview.

      In BO, I have a Folder structure defined which contains reports in it. Approximately there are around 100 reports in BO.

       

      I want to create only one .qvw file which should contain these 100 reports.

       

      Is there any solution in qlikview where I can create same folder structure(as of BO) in a sheet so that when the user navigates in qlikview he can get the feel as if he is working with BO.

       

      Please suggest.

       

       

      Thanks,

      Vivek

        • Re: Folder Navigation in QLikview
          Jonathan Brough

          Sounds like you need to achieve three objectives:

          1. Read data in

          You can read the data into QlikView using the For Each .... IN DirList(Dir) and For Each .... IN FileList(Dir) commands.

          2. Organise reports

          You can up a hierarchial structure using the Hierarchy command with the directory names as nodes. You would would probably only need to do this as a linked table for presentation purposes

          3. Present data

          You could use a pivot table, maybe with indent mode ticked in the Style properties, to show the hierarchy, collapsing it when a report has been choosen. A search box alongside that would also be useful.

          Jonathan