topic Re: Display problem in QlikView

Display problem

Wed, 12 Dec 2012 20:47:00 GMT

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
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.

Re: Display problem

MayilVahanan — Wed, 12 Dec 2012 21:00:25 GMT

Try with Hierarchy concept

Ex:

http://community.qlik.com/message/206268#206268

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

CELAMBARASAN — Wed, 12 Dec 2012 21:06:14 GMT

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

Re: Display problem

Wed, 12 Dec 2012 21:21:51 GMT

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.

AAA

Re: Display problem

Wed, 12 Dec 2012 21:30:22 GMT

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.

AAA

Re: Display problem

Wed, 12 Dec 2012 21:31:32 GMT

I need the overall totals of all the projects also.

Pivot chart will not give me that.

Re: Display problem

Wed, 12 Dec 2012 21:31:37 GMT

I need the overall totals of all the projects also.

Pivot chart will not give me that.

Re: Display problem

CELAMBARASAN — Wed, 12 Dec 2012 21:46:52 GMT

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.