Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display problem

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

ProgramProjectData1Data2
A1AAAd1d2
A1BBBc1d1
C1CCCc2d4
C1DDDc3d5

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/Projectdata1data2Header 4
A1

    AAA   

d1d2
    BBBc1d1
C1
   CCCc2d4
   DDDc3d5

How can i achieve this.

thanks in advance for you help.

7 Replies
MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

May be you can think of Pivot table for this case.

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

I need the overall totals of all the projects also.

Pivot chart will not give me that.

Not applicable
Author

I need the overall totals of all the projects also.

Pivot chart will not give me that.

CELAMBARASAN
Partner - Champion
Partner - Champion

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.