topic Hierarchy format /Pivot table prob in QlikView

Hierarchy format /Pivot table prob

Thu, 12 Jan 2012 21:00:05 GMT

Hi All:

I am having trouble in creating a format like the following. I am using Pivot table.

Any help is greatly appreciated.

Metric Curr Period Prev Period Diff(Prev-Curr)

+ Total Book1 1500 1200 300

B1 500 500 0

B2 500 500 0

B3 500 200 300

+ Total L1 2000 600

L1 500 200

L2 1000 200

L3 500 200

The + symbol i am using to denote the collapse functionality.

In the starting user will see just

+Total Book 1 1500

+ Total L1 2000

But when he clicks on +, he can see/expands the details underneath each item.

Also sorting is specific , it has to be B1,B2,B3.. To use specific sorting i am using Sortorder number but sort order number has to be selected in the pivot table for it to work and there is no way to hide it in the pivot table.

I have tried to use Inline table to create this.Used Parent KPI and Child KPIs to get B1 under Total Book 1 etc.

but unable to get the required format.

Thanks.