Discussion board where members can get started with QlikView.
I am using straight table to display my data.
Program is a parent of Project.
Currently I am displaying the data in the following format
but user don't want to see Programs and Projects in 2 separate columns.
They want Program/project to be displayed in one column with Project indented.
Some thing like this
How can i achieve this.
thanks in advance for you help.
Try with Hierarchy concept
Hierarchy use oly in list box n not in chart . Not possible for chart upto my knowledge
May be you can think of Pivot table for this case.
I am able to get the hierarchy where i can get Projects related to programs.
But i am unable to get the format where Programs and Projects are displayed in one column.Projects underneath are indented.
I need the overall totals of all the projects also.
Pivot chart will not give me that.
It will give by using Partial sum option.
Did you checked the option in the Persentation tab?
choose the project field and select Show Partial sum option.