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.
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.
The solutions which you suggested was very helpful. Thanks a lot.
I concatenated all the columns with a separator "/". In Qlikview I used the option of "Show as TreeView" in the Properties of ListBox. Qlikview on its own generatesd the Folder Structure for me.
