Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Display problem

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

Re: Display problem

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

Not applicable

Re: Display problem

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

Re: Display problem

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

Re: Display problem

I need the overall totals of all the projects also.

Pivot chart will not give me that.

Not applicable

Re: Display problem

I need the overall totals of all the projects also.

Pivot chart will not give me that.

Re: Display problem

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.

Community Browser