Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys:
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
Program | Project | Data1 | Data2 |
---|---|---|---|
A1 | AAA | d1 | d2 |
A1 | BBB | c1 | d1 |
C1 | CCC | c2 | d4 |
C1 | DDD | c3 | d5 |
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
Program/Project | data1 | data2 | Header 4 |
---|---|---|---|
A1 | |||
AAA | d1 | d2 | |
BBB | c1 | d1 | |
C1 | |||
CCC | c2 | d4 | |
DDD | c3 | d5 |
How can i achieve this.
thanks in advance for you help.
Hi
Try with Hierarchy concept
Ex:
http://community.qlik.com/message/206268#206268
or
http://community.qlik.com/message/93560#93560
Edit:
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.
Thanks.
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.
A1
AAA
Thanks.
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.
A1
AAA
I need the overall totals of all the projects also.
Pivot chart will not give me that.
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.